codine24/7's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
Active Members
Active Posts:
55 (0.05 per day)
Joined:
12-February 12
Profile Views:
1,252
Last Active:
User is offline Jul 26 2013 04:25 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   codine24/7 has not set their status

Posts I've Made

  1. In Topic: took privileges away from root

    Posted 2 Jun 2013

    View PostAtli, on 02 June 2013 - 01:37 PM, said:

    If you have access to a terminal (through SSH or telnet?) then you should be able to stop the MySQL server and re-start it with the --skip-grant-tables option. That should allow you to log in with any user and modify the user permissions as needed, and then restart the server normally once you're done.

    The --skip-grant-tables option basically skips the entire user privileges part of the server, giving every user root-like permissions.



    i did that and i had to run this file to allow me to restart the mysql server and be able to grant privileges

    mysql -vv < restore_root_privileges.sql

    update mysql.user set Super_priv='y' where user='root';
    update mysql.user set Select_priv='y' where user='root';
    update mysql.user set Insert_priv='y' where user='root';
    update mysql.user set Update_priv='y' where user='root';
    update mysql.user set Delete_priv='y' where user='root';
    update mysql.user set Create_priv='y' where user='root';
    update mysql.user set Drop_priv='y' where user='root';
    update mysql.user set Reload_priv='y' where user='root';
    update mysql.user set Shutdown_priv='y' where user='root';
    update mysql.user set Process_priv='y' where user='root';
    update mysql.user set File_priv='y' where user='root';
    update mysql.user set Grant_priv='y' where user='root';
    update mysql.user set References_priv='y' where user='root';
    update mysql.user set Index_priv='y' where user='root';
    update mysql.user set Alter_priv='y' where user='root';
    update mysql.user set Show_db_priv='y' where user='root';
    update mysql.user set Super_priv='y' where user='root';
    update mysql.user set Create_tmp_table_priv='y' where user='root';
    update mysql.user set Lock_tables_priv='y' where user='root';
    update mysql.user set Execute_priv='y' where user='root';
    update mysql.user set Repl_slave_priv='y' where user='root';
    update mysql.user set Repl_client_priv='y' where user='root';
    update mysql.user set Create_view_priv='y' where user='root';
    update mysql.user set Show_view_priv='y' where user='root';
    update mysql.user set Create_routine_priv='y' where user='root';
    update mysql.user set Alter_routine_priv='y' where user='root';
    update mysql.user set Create_user_priv='y' where user='root';

    Thank you very much
  2. In Topic: took privileges away from root

    Posted 2 Jun 2013

    View PostAtli, on 02 June 2013 - 01:37 PM, said:

    If you have access to a terminal (through SSH or telnet?) then you should be able to stop the MySQL server and re-start it with the --skip-grant-tables option. That should allow you to log in with any user and modify the user permissions as needed, and then restart the server normally once you're done.

    The --skip-grant-tables option basically skips the entire user privileges part of the server, giving every user root-like permissions.


    that worked somewhat

    but now i get this

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;


    ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

    is

    THANKS for the speedy reply btw

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Click here to e-mail me

Friends

codine24/7 hasn't added any friends yet.

Comments

codine24/7 has no profile comments yet. Why not say hello?