mysql start problems

Ab3n · 05-04-2005, 11:13 PM

I just installed apache, php, and mysql using the following site: http://www.insyte.uni.cc/
but every time I try to start mysql I get this:

Code:

bash-3.00# mysqld_safe --user=mysql &
[1] 2518
bash-3.00# Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/darkstar.pid
050504 22:10:51  mysqld ended


[1]+  Done                    mysqld_safe --user=mysql
bash-3.00# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists!
bash-3.00#

rakriege · 05-04-2005, 11:36 PM

sql must run as a service, make sure it has the correct permissions

Ab3n · 05-04-2005, 11:37 PM

how do I do that?

rylan76 · 05-05-2005, 01:20 AM

Do you have a source or binary MySQL package?

Here's how I installed and configured my MySQL (4.0.16):

1. Install according to BINARY_INSTALL.TXT
2. Do chown -R mysql.mysql /var/lib/mysql
3. Go to /var/run
4. mkdir mysqld
5. chown -R mysql.mysql mysqld
6. Start the server - mysqld_safe --user=mysql & in the /usr/local/mysql/bin/
directory
7. Type in mysql -u root mysql
8. At mysql> prompt type
set password for root@localhost=password('arendia');

Example:

[root@StefanLinux rylan]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for root@localhost=password('password');

This assumes that you have a binary MySQL install.