1

I am having an error after i've uploaded my website saying

Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation

I have searched with the same matter on google and i have found some saying my.ini is needed to be configured

But i dont know where that my.ini file is even located. Will that solve my problem if configured properly? Where can i find it?

Any advice will surely be appreciated

thanks in advance

kristyan markes
  • 37
  • 1
  • 2
  • 8

1 Answers1

0

First of all i would recommend you to use GRANTS

SO first run the command SHOW GRANTS; which displays the privileges granted explicitly to the named account.

Try loggin in with root permission

mysql -uroot

If you cant login with the root permission..

Make some changes to the ini file

[mysqld] skip-grant-tables skip-networking

and do a restart.

Avinash Babu
  • 6,171
  • 3
  • 21
  • 26
  • It'll be very bad to skip the grant tables. You should set the correct permissions and better use `mysql -uroot -p`. Then you could grant the right privileges in mysql via `GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost';` – jankal Nov 01 '14 at 09:00
  • i'm sorry sir but i'm really not getting you. how am i albe to loggin with root permission? may you please be more specific? and as i have said on my post that i even dont know the location/directory of that ini file i reall am sorry sir really noob with that matter thanks – kristyan markes Nov 01 '14 at 14:45
  • see this http://stackoverflow.com/questions/11946012/how-to-add-super-privileges-to-mysql-database..accept the ans if it helps .thanx – Avinash Babu Nov 01 '14 at 14:53