Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
 Topic: Cannot get access to MySQL |
|
| Author |
|
kr33
Joined: 19 Sep 2006
Posts: 64
Location: South Africa
|
 Posted: Thu 21 Sep '06 15:23 Post subject: Cannot get access to MySQL |
 |
|
Hi
I seem to be having trouble getting access to MySQL. When I go to the command line terminal and change directories to the MySQL directory and try to start up MySql to view the databases I get an error along the lines of 'Access Denied....ODBC@localhost (using password: NO)'. Well thats the crux of it.
So in order for me to gain access I have to type the following:
mysql -h localhost -u root -p
then when prompted for the root password, i enter it and then I can access mySQL.
Is this normal?  |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7298
Location: Germany, Next to Hamburg
|
| Posted: Thu 21 Sep '06 15:42 Post subject: |
|
|
Under Windows 2000/XP/2003 you should start mySQL like in my example if you don't run it as service.
| Code: |
mysql\bin\mysqld-nt --standalone
|
shutting down with root user and empty password
| Code: |
mysql\bin\mysqladmin -u root shutdown
|
|
|
| Back to top |
|
|
|
|
|
|
