CODEWITHSUNDEEP
phpmysqlphpmyadmin
SilverLight
SilverLight

Reputation: 20468

How Switch User And Backup A DataBase In MySql With Current User(Logged In User)?

i am using phpmyadmin for connecting to mysql.
my current user have some limitations for viewing all databases.
also i can not change the current user of phpmyadmin and login with admin user because i am in cpanel.
i have administrator user name and password.
which sql query should i use for switch to admin user and backup databases that that user can see?
also how can i download that sql file to my local machine?

Upvotes: 0

Views: 681

Answers (1)

Hiren Soni
Hiren Soni

Reputation: 574

UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

Upvotes: 2

Related Questions