Re: mysql upgrade fails to work

  • From: "Octavian Rasnita" <orasnita@xxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Fri, 2 Nov 2007 17:17:13 +0200

It is recommended to use just

mysql -u root -p database_name

and 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

Other related posts: