LinuxQuestions.org - mysql start problems

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - mysql start problems (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-start-problems-320259/)

mysql start problems

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#

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

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.