Different help needed!
Posted 26 June 2003 - 02:03 PM
I\'ve run the WinMySQLadmin thing and provided username and password at the prompt for the my.ini file - j and j
Now, upon trying to connect to the server using
mysql -h localhost -u j -pj
i get this error.
ERROR 1045: Access denied for user: \'firstname.lastname@example.org\' (Using password: YES)
What am i doing wrong? Shouldn\'t that work.
I read the manual and it said something about making a root user with a password so i followed those instructions and used the username root and its password but got the same error except j@ was root@
what am i getting wrong? Shouldn\'t the username and password shown in the my.ini file work?
Again, thanks for the help.
Posted 26 June 2003 - 02:39 PM
Try using the user \"root\" with NO password ( Hope u havent set one)
in the mysql database check the user table and flush the password
Posted 26 June 2003 - 06:55 PM
Also. What is the username and password set in the my.ini file for?
Im guessing after logging in with root i can just add new users with their own privilleges etc? Right?
I hate to sound retarded but i am new to this.
Posted 27 June 2003 - 05:26 AM
choose the mysql database
and u will see a table names user
try adding new user in that
if u are using windows u can download the sqlyog tool from www.sqlyog.com which has a GUI based interface for doing this!
Posted 29 June 2003 - 08:37 PM
I cant connect and i have no other user. is there a way to correct this?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users