Jump to content

Archived

This topic is now archived and is closed to further replies.

Joei

Different help needed!

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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. :D

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.