Different help needed!

[Joei]

Ok, scrap that problem. I have a new one. I\'ve installed an earlier version after realising i was using a beta. No slow down problems etc and everything seems fine.

 

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: \'j@127.0.0.1\' (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.

[shivabharat]

Your commands look ok!!

 

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

[Joei]

Thanks for the help. That worked, i am logged in as root. m, how do i access the user table? Why do i want to flush the password?

 

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.

[shivabharat]

To add new user

 

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!

[mixmaster]

hello, i accidentally used sqlyog to kill the root user, at least thats what i think i did.

 

I cant connect and i have no other user. is there a way to correct this?