On 8/8/06, Yves Goergen <[EMAIL PROTECTED]> wrote:
Hello,
I was just trying out the mysql_upgrade script on my MySQL 5.0 server
but it shows an error message that makes me believe it doesn't know
where to find its own data.
Here's what I did:
mysql_upgrade --basedir=/usr/local/mysql5 --datadir=/var/mysql5/data
--password
And this is what I got:
Enter password: [so did I]
/usr/local/mysql5/bin/mysqlcheck: Got error: 2002: Can't connect to
local MySQL server through socket '/tmp/mysql.sock' (2) when trying to
connect
Could not find MySQL command-line client (mysql).
Please use --basedir to specify the directory where MySQL is installed.
The correct socket to connect to would be /var/tmp/mysql5.sock which is
written in the my.cnf file in the given datadir. And 'mysql' is in the
$PATH so my shell finds it without a problem.
Are you sure about that ?
Notice that you're installing into /usr/local/mysql5 which is NOT a
standard path.
Maybe it's finding an old version, check it:
mysql --version
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]