Dear All,
I reinstalled the Linux (SuSE Linux ver 8.0) on my machine and selected MySQL from the Linux CD itself. While starting mysqld daemon through safe_mysqld script, it is giving the following Error and daemon has ended immediatly. I had pasted the messages on my screen below. Kindly let me know how can I start mysqld daemon on my system.
Run mysql_install_db (as you apparently did during the first install), but either run it while logged in as mysql, or run it as root with a --user=mysql argument.
You must run mysql_install_db to initialize the data directory, but you want the directories and files that it creates to be owned by mysql.
After you run mysql_install_db, you should be able to run safe_mysqld.
---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------------------------------------- emclinuxserver:~ # safe_mysqld --user=mysql & [1] 3364 emclinuxserver:~ # Starting mysqld daemon with databases from /var/lib/mysql ERROR LOG /var/lib/mysql/mysqld.log 030311 16:00:39 mysqld ended
[1]+ Done safe_mysqld --user=mysql emclinuxserver:~ # emclinuxserver:~ # emclinuxserver:~ # emclinuxserver:~ # emclinuxserver:~ # emclinuxserver:~ # cat /var/lib/mysql/mysqld.log 030311 16:00:39 mysqld started 030311 16:00:39 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030311 16:00:39 mysqld ended
emclinuxserver:~ #
---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------------------------------------- I changes the umask value by setting the file permissions to all, but it didn't worked.
NOTE: emclinuxserver is hostname.
Request you reply ASAP.
Best Regards... -Harish
> See the manual for more instructions.-----Original Message----- From: Dan Rossi [SMTP:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:29 AM To: Harish B M (RBIN/ECM2) *; [EMAIL PROTECTED] Cc: Pemmaiah B D (RBIN/ECM2) * Subject: RE: Error while starting mysqld ....
/var/lib/mysql/ i think that path needs to writable 777 so it can write the socket to it
-----Original Message----- From: Harish B M (RBIN/ECM2) * [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 7:51 PM To: '[EMAIL PROTECTED]' Cc: Pemmaiah B D (RBIN/ECM2) * Subject: Error while starting mysqld ....
> Hello, > > I am trying to install MySQL version 3.23 database server (Downloaded from Internet) on a Intel Pentium III machine installed with SuSE Linux 8.0 Professional. While starting the mysqld daemon, it is giving the following Error. > > Can't connect to the local MySQL server through socket /usr/lib/mysql/mysql.sock > > Kindly let me know what has gone wrong and how to overcome it. > The installation Procedure followed is: -------------------------------------------------------------------------- -- -----------------------------------
Created a group mysql Created a user with mysql as ID # cd /usr/local # ln -s /usr/local/mysql-max-3.23.55-pc-linux-i686 mysql # cd mysql
# scripts/install_mysql_db
When the above script is executed, the output is
Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 030306 13:49:36 ./bin/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h emclinuxserver password 'new-password'> > Harish
You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com
# chown -R root . # chown -R mysql data # chgrp -R mysql . # bin/safe_mysqld --user=mysql &
Then it is giving the following message
mysqld Started Can't start Server: Bind on Unix socket: Permission Denied Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
Aborting
/usr/sbin/mysqld : SHutsown Complete
mysqld ended
-------------------------------------------------------------------------- -- -----------------------------------
I donot have any other mysqld running, I don't understand why the daemon can't be started. I request you all to let me know what had gone wrong and how can I start the mysqld daemon.
> Best Regards...
--------------------------------------------------------------------- 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
