It is recommended to use just mysql -u root -p database_nameand then supply the password at the command prompt, because this way it won't be logged.
Octavian----- Original Message ----- From: "Andy B" <a_borka@xxxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx> Sent: Friday, November 02, 2007 4:44 PM Subject: RE: mysql upgrade fails to work Hi... Actually, the command would be: mysql -u root -pMypassword databaseName **note** that the -pPassword switch requires that the -p and your password not have spaces between them. Otherwise it will think your password is a db name and just think you want to be prompted for the password. I have also tried to use super user root without a password and also making it a local user only. This seems to be the only way I can get it to work. It isn't a good idea and even the newer mysql versions may refuse to let a user not have a password. -----Original Message----- From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of jaffar Sent: Friday, November 02, 2007 10:29 AM To: programmingblind@xxxxxxxxxxxxx Subject: mysql upgrade fails to work Hi All. Need some advise from you mysql experts. I just tried to upgrade my mysql to the most recent version. The older version worked just fine, but after the upgrade, i couldn't connect to mysql via the command prompt. I get an access denied message. I tried changing my password, retaining root as user, but to no avail. In fact, the message i got from the failed connection attempt was, access denied to ODBC@localhost using password no when i have explicitly set root as super user with no password. So i created a new password for superuser root, which is myself. When i issued the command "mysql -u root, -p myPassword, i got a prompt to enter my changed password, but upon entering it, i get a message, no such database, myPassword. However, and this is the strange thing, I am able to connect to mysql through php via phpmyadmin. I have created all the environment variables necessary. And one more thing, when i tried to telnet to port 3306, i get the message, couldn't telnet to port3306 using port 23, connection failed. Now, i am wondering if during the uninstallation process of the older mysql software, something was left behind blocking the connection port or some such. I even tried to trace the registry to check if any fragment of the older mysql was left behind, but to no avail. Sorry for the rant, but i am really stuck here and need help which the mysql documentation could not give. Cheers and thanks. __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind __________View the list's information and change your settings at //www.freelists.org/list/programmingblind