Hi, I Installed mysql from the suse CDs (8.1), started it by the init.d script got all the tables etc. created.. tried to connect to it from another system. This is what I see on the console inetbox:/etc/init.d # mysqladmin ping mysqld is alive inetbox:/etc/init.d # /usr/bin/safe_mysqld: line 1: 7509 Segmentation fault nice --5 nohup /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking --skip-grant-tables
/var/lib/mysql/mysqld.log 2>&1
Number of processes running now: 1 mysqld process hanging, pid 7512 - killed 030129 14:53:58 mysqld restarted I do not understand what the problem here is !! When I am on the same system I am able to connect using mysql client without specifying a password for root user. I presume there is some problem with the grants / the basic tables of mysql itself. though I even inserted a new user into the table but to no effect. mysql> select * from user -> ; +-----------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | inetbox | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | localhost | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | inetbox | | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | % | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +-----------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ 5 rows in set (0.00 sec) I still am not able to connect to the system from any other system. I am sure a lot of people must have come across the same problem and must have got over it... please help.. vishal
From: "Vishal Khanna"
Hi, I Installed mysql from the suse CDs (8.1), <snip>
From my experience, download the MySQL rpms from mysql.com and install these. Installing SuSE's version of MySql causes problems.
__________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
participants (2)
-
Linux World 999
-
Vishal Khanna