0

i created a new user with all the privileges in mysql and it didn't work. no user works except "root with no password" which is why i created several user and tried it...still didn't work....if anyone know what is wrong....please lemme know....

thank you....

4
Contributors
6
Replies
7
Views
8 Years
Discussion Span
Last Post by web_master
0

What does the error message say?

It depends on your error message
if its says access denied then it the problem with mysql /username/password
but if its saying can't reach mysql server its the connectivity problem

0

mysql can disable access by host aswell as username/password

eg. user@localhost may work, but user@169.1.1.1 wont.

GRANT ALL ON mydb.* TO 'someuser'@'somehost';

will allow all hosts

GRANT ALL ON mydb.* TO 'someuser'@'%';
0

Thanks for the reply.

I did:

GRANT ALL ON mydb.* TO 'username'@'localhost';

but there is a password in this user thats y it probably it gives an error. "couldn't find the field in table users."

and for reference the error it shows in my web app is:

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user 'username'@'localhost' (using password: YES)

and works perfectly fine if i use root with no password.

0

i don't get it....phpMyAdmin shows an error...

#1133 - Can't find any matching row in the user table

when i entered:

GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'localhost' IDENTIFIED BY 'password';

i have checked it at-least 20 times if i was making a mistake somewhere....but i cant seem to find any....i'm doing exactly what you're saying....how can it not find that field when i can see it...

and when i made this user i did grant all the privileges if thats what the above command is for.

and thanks for the password on root tip....i do have a password now....thanks....

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.