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.

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.

What are those for? dcom what?

Hey. I\'m new to MySQL, and trying to teach myself from a book. The problem is, i can\'t seem to get it to run properly. I have MySQ 4.0.4 beta running on Windows 98. The thing is, the book tells me to run WinMySqlAdmin which automatically runs the mysqld-opt server. So i do. Except when the server is running it slows down my comp. and when i try to connect to the server in DOS it just sits there and doesn\'t do anything. I am typing mysql -u j (my username) -p I then type my password at the prompt which is also j. I\'ve tried variations of this command. For example - mysql -h localhost -u j -p but still the same. If i don\'t have the server on, when i try these commands to connect to the server i get the error \"ERROR 2003: Can\'t connect to MySQL server on \'localhost\' (10061)\" which makes sense since the server isn\'t on. but as i said, when the server is on, it just sits there and i get no feedback. and i have tried all the commands which are supposed to write errors to a text file etc - but still nothing. Now if i close the mysqld-opt server i get the error about where it has lost contact with the server during a query which also makes sense. The strange thing is, i spent hours trying to get this all to work, and then the next day i somehow got it to work in no time. I was connected to the server and everything and there was no sign of slowdown. I could issue the mysql commands and stuff. The thing that\'s strange is, when i asked it to connect to the server, i could have sworn there was no server running so i am bamboozled. I have no idea what it is i am doing wrong. I am really desperate and would appreciate any help on getting the whole thing working correctly so i can teach myself it. I\'m really desperate here and don\'t know where else to turn. I\'ve read the manual countless times and am getting nowhere. Thanks in advance.