At 6:08 +0100 3/11/03, Harish B M (RBIN/ECM2) * wrote:
>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
>
>> -----Original Message-----
>> From: Dan Rossi [SMTP:daniel@stripped]
>> Sent: Friday, March 07, 2003 1:29 AM
>> To: Harish B M (RBIN/ECM2) *; mysql@stripped
>> 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:bm.harish@stripped]
>> Sent: Thursday, March 06, 2003 7:51 PM
>> To: 'mysql@stripped'
>> 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'
> > See the manual for more instructions.
>>
>> 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...
> > > Harish
