Hi, I removed an old mysql version and I installed a new one on a machine running Suse 8.1 Linux. shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm shell>rpm -qa | grep -i mysql shell>reboot
shell>safe_mysqld --user=mysql & shell>ps -ax ... 961 pts/0 S 0:00 /bin/sh /usr/bin/safe_mysqld --user=mysql 977 pts/0 S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql 979 pts/0 S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql 980 pts/0 S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql ... shell>mysqladmin -u root password 'new-password' shell>mysqladmin -u root -h hostname password 'new-password' mysqladmin: connect to server at 'hostname' failed error: 'Can't connect to MySQL server on 'hostname' (110)' Check that mysqld is running on hostname and that the port is 3306. You can check this by doing 'telnet hostname 3306' shell>telnet hostname 3306 Trying IP_address... telnet: connect to address IP_address: Connection timed out shell>mysqladmin -u root password 'new-password' mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I can only use mysql with mysql user: shell>mysql -u mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show databases; +----------+ | Database | +----------+ | mysql | | test | +----------+ 2 rows in set (0.00 sec) mysql> quit Bye What's the problem ? Help me please. Thanks in advance. Adi --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
