Joei Posted June 26, 2003 Share Posted June 26, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/639-different-help-needed/ Share on other sites More sharing options...
shivabharat Posted June 26, 2003 Share Posted June 26, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/639-different-help-needed/#findComment-2135 Share on other sites More sharing options...
Joei Posted June 26, 2003 Author Share Posted June 26, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/639-different-help-needed/#findComment-2137 Share on other sites More sharing options...
shivabharat Posted June 27, 2003 Share Posted June 27, 2003 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! Quote Link to comment https://forums.phpfreaks.com/topic/639-different-help-needed/#findComment-2148 Share on other sites More sharing options...
mixmaster Posted June 29, 2003 Share Posted June 29, 2003 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? Quote Link to comment https://forums.phpfreaks.com/topic/639-different-help-needed/#findComment-2170 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.