Having trouble starting server

[sethbaur]

I have no experience with mySQL whatsoever and I just installed it on my linux box using the documentation on the mySQL site.

 

When I used the command:

 

bin/mysqld_safe --user=mysql &

 

to start the server it gives me the following message before stopping the server:

 

[2] 4105

[1] Done bin/mysqld_safe --user=mysql

[root@weston mysql]# Starting mysqld daemon with databases from /var/lib/mysql

STOPPING server from pid file /var/run/mysqld/mysqld.pid

070205 18:38:15 mysqld ended

 

Error log:

 

070205 18:48:12 mysqld started

InnoDB: The first specified data file ./ibdata1 did not exist:

InnoDB: a new database to be created!

070205 18:48:12 InnoDB: Setting file ./ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

070205 18:48:14 InnoDB: Log file ./ib_logfile0 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

070205 18:48:15 InnoDB: Log file ./ib_logfile1 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

070205 18:48:16 InnoDB: Started; log sequence number 0 0

070205 18:48:16 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)

070205 18:48:16 [ERROR] Can't start server: can't create PID file: No such file or directory

070205 18:48:16 mysqld ended

 

Any ideas on what I've done wrong? Being that I'm such a newbie, it most likely is something simple, but I'm stuck.

[shoz]

I usually use the tar.gz from mysql.com for my installations and the pid by default is stored in the data directory which mysql owns. I assume this is a package install. Try creating the /var/run/mysqld dir and give user mysql ownership.

 

mkdir /var/run/mysqld
chown mysql. /var/run/mysqld