Hello,
Since I had problems with my previous MySQL installation anf phpMyAdmin
I have installed the new version of MySQL(Ver 8.41 Distrib 5.0.22)
from Internet Express version 6.6 for Tru64 CD.I have installed only
MySQL from the CD on my Tru64 OS V5.1A machine.The installation went
without
any problems as given in the following output:
"The latest information about MySQL is available on the web at
http://www.mysql.com
done
*****************************************************
Internet Express IAEMYSQL660
installation completed successfully.
*****************************************************
Configuring "MySQL v5.0.22" (IAEMYSQL660)
Starting MySQL
. SUCCESS!
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/internet/mysql/bin/mysqladmin -u root password 'new-password'
/usr/internet/mysql/bin/mysqladmin -u root -h machine.psi.ch password
'new-password'
See the manual for more instructions."
So I tried the following commands to set the password without any
success:
TEST1
-----
/usr/internet/mysql/bin/mysqladmin -u root password 'test01'
/usr/internet/mysql/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user 'root'_at_'localhost' (using password: NO)'
TEST2
------
/usr/internet/mysql/bin/mysqladmin -u 'root' password 'test01'
/usr/internet/mysql/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user 'root'_at_'localhost' (using password: NO)'
TEST3
-----
/usr/internet/mysql/bin/mysql -u 'root'_at_'localhost'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 48 to server version: 5.0.22-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> set password for 'root'_at_'localhost'=password('test01');
ERROR 1044 (42000): Access denied for user ''_at_'localhost' to database
'mysql'
mysql>
TEST4 (running test cases)
-----
/usr/local/mysql>bin/mysqltest
mysqltest: Could not open connection 'default': 1045 Access denied for
user 'root'_at_'localhost' (using password: NO)
not ok
TEST5
--------
$mysqladmin -u 'root'_at_'localhost' version
bin/mysqladmin Ver 8.41 Distrib 5.0.22, for dec-osf5.1a on alphaev56
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.22-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /usr/local/mysql/tmp/mysql.sock
Uptime: 7 min 55 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 0 Flush tables: 1
Open tables: 6 Queries per second avg: 0.015
TEST6 (Process status)
-----
$ps auxww|grep mysql
mysql 36697 0.0 12.0 98.0M 61M pts/1 S 10:52:56
0:01.57 /usr/internet/mysql/libexec/mysqld --basedir=/usr/internet/mysql
--dat
adir=/usr/local/mysql/var --user=mysql
--pid-file=/usr/local/mysql/var/test01.psi.ch.pid --port=3306
--socket=/usr/local/mysql/tmp/mysql.sock
root 36678 0.0 0.0 2.68M 240K pts/1 I 10:52:56
0:00.02 /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/var
--pid-
file=/usr/local/mysql/var/test01.psi.ch.pid
TEST7
------
I the previous MySQL installation on this machine(
mysql-standard-5.0.0-alpha-dec-osf5.1-alphaev67)
I never had any such problems. If I execute the following command I can
see the default databases.
$mysql -u 'root'_at_'localhost'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 5.0.22-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test |
+--------------------+
2 rows in set (0.02 sec)
What is wrong with my installation? How can I set a password for
root?
I have the following directories in /usr/local/mysql:
$ls -l
total 104
drwxr-xr-x 2 mysql mysql 8192 Sep 18 16:01 bin
drwxr-xr-x 3 mysql mysql 8192 Sep 18 16:01 include
drwxr-xr-x 2 mysql mysql 8192 Sep 18 16:01 info
drwxr-xr-x 3 mysql mysql 8192 Sep 18 16:01 lib
drwxr-xr-x 2 mysql mysql 8192 Sep 18 16:01 libexec
drwxr-xr-x 2 mysql mysql 8192 Sep 18 16:03 logs
drwxr-xr-x 3 mysql mysql 8192 Sep 18 16:01 man
drwxr-xr-x 7 mysql mysql 8192 Sep 18 16:02 mysql-test
drwxr-xr-x 3 mysql mysql 8192 Sep 18 16:03 share
drwxr-xr-x 5 mysql mysql 8192 Sep 18 16:03 sql-bench
drwxrwx--- 2 mysql mysql 8192 Sep 19 12:10 tmp
drwxr-x--- 4 mysql mysql 8192 Sep 19 12:10 var
Any help is appreciated?
Thanks in advance.
Regards,
Kumar
------------------------------------------------------------------
Padiyath Sreekumar | Tel: +41.56.310.3643
Paul Scherrer Institut | email: kumar.padiyath_at_psi.ch
AIT | Office: WHGA/U132
WHGA/U132 | Fax: +41.56.310.3649
CH-5232 Villigen PSI |
Switzerland |
-----------------------------------------------------------------
Received on Wed Sep 19 2007 - 11:51:44 NZST