Jump to content


Photo

Different help needed!


  • Please log in to reply
4 replies to this topic

#1 Joei

Joei
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 26 June 2003 - 02:03 PM

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.

#2 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 26 June 2003 - 02:39 PM

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
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#3 Joei

Joei
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 26 June 2003 - 06:55 PM

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

#4 shivabharat

shivabharat
  • Members
  • PipPipPip
  • Advanced Member
  • 371 posts
  • LocationChennai, India

Posted 27 June 2003 - 05:26 AM

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!
Knowledge --- Reading Enriches Mind But Sharing Enhances It.[br][br]Note: Before you request help enusre that you have had a look at the tutorials @phpfreaks

#5 mixmaster

mixmaster
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 29 June 2003 - 08:37 PM

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?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users