Hello all. I am trying to setup MySQL on SuSE however when I try to use MySQL I get ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Any ideals what I am doing wrong? or how I can configure MySQL on SuSE?
Have you installed the version of mysql bundled with SuSE? I have a similar problem. After installing MySQL, have you run the command "mysql_install_db"? If not, run this command. This is a "one off" command that does not need running again under normal circumstances. To start mysql use: "safe_mysqld --user=root &" This usually kicks off mysql on the pc here. Hope this helps. LW999 On Thursday 02 January 2003 02:20, Terry Ashley wrote:
Hello all. I am trying to setup MySQL on SuSE however when I try to use MySQL I get ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Any ideals what I am doing wrong? or how I can configure MySQL on SuSE?
"safe_mysqld --user=root &" Note the spaces above. On Thursday 02 January 2003 20:54, Linux World wrote:
Have you installed the version of mysql bundled with SuSE? I have a similar problem. After installing MySQL, have you run the command "mysql_install_db"? If not, run this command. This is a "one off" command that does not need running again under normal circumstances. To start mysql use:
"safe_mysqld --user=root &"
This usually kicks off mysql on the pc here.
Hope this helps.
LW999
On Thursday 02 January 2003 02:20, Terry Ashley wrote:
Hello all. I am trying to setup MySQL on SuSE however when I try to use MySQL I get ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Any ideals what I am doing wrong? or how I can configure MySQL on SuSE?
On Thu, 2 Jan 2003, Linux World wrote:
Have you installed the version of mysql bundled with SuSE? I have a similar problem. After installing MySQL, have you run the command "mysql_install_db"? If not, run this command.
Actually: Don't run mysql_install_db manually. Just start MySQL with "rcmysql start" and it will run mysql_install_db automatically as the proper mysql user, so MySQL does not have to run as root.
This is a "one off" command that does not need running again under normal circumstances. To start mysql use:
"safe_mysqld --user=root &"
This is also included in rcmysql start Regards Ole
----- Original Message -----
From: "Ole Kofoed Hansen"
On Thu, 2 Jan 2003, Linux World wrote:
Have you installed the version of mysql bundled with SuSE? I have a similar problem. After installing MySQL, have you run the command "mysql_install_db"? If not, run this command.
Actually: Don't run mysql_install_db manually. Just start MySQL with "rcmysql start" and it will run mysql_install_db automatically as the proper mysql user, so MySQL does not have to run as root.
This is a "one off" command that does not need running again under normal circumstances. To start mysql use:
"safe_mysqld --user=root &"
This is also included in rcmysql start
When using rcmysql mysql does not start and hangs. Manually issuing the command "safe_mysqld" works. A better solution is to download the RPMs from MySql's site, install them manually using RPM commmand line and run the "mysql_install_db" once. After that, starting and stopping mysqljis easier. Using SuSE's bundled MySql package has its 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
On Mon, 6 Jan 2003, Linux World 999 wrote:
----- Original Message ----- From: "Ole Kofoed Hansen"
On Thu, 2 Jan 2003, Linux World wrote:
Have you installed the version of mysql bundled with SuSE? I have a similar problem. After installing MySQL, have you run the command "mysql_install_db"? If not, run this command.
Actually: Don't run mysql_install_db manually. Just start MySQL with "rcmysql start" and it will run mysql_install_db automatically as the proper mysql user, so MySQL does not have to run as root.
This is a "one off" command that does not need running again under normal circumstances. To start mysql use:
"safe_mysqld --user=root &"
This is also included in rcmysql start
When using rcmysql mysql does not start and hangs. Manually issuing the command "safe_mysqld" works.
This is quite likely because you had run mysql_install_db as root. Then MySQL's private databases are owned by root, and cannot be read by the mysql user that SuSE's rpms are set to use.
A better solution is to download the RPMs from MySql's site, install them manually using RPM commmand line and run the "mysql_install_db" once. After that, starting and stopping mysqljis easier. Using SuSE's bundled MySql package has its problems.
I have only had problems with SuSE's MySQL packages once and that was when I manually ran mysql_install_db. Regards Ole
participants (4)
-
Linux World
-
Linux World 999
-
Ole Kofoed Hansen
-
Terry Ashley