lamstack, Problem starting mysql

root@testpig:/home/maal11/lampstack-1.2-0# ./ctlscript.sh start mysql
100602 14:45:45 mysqld_safe Logging to ‘/home/maal11/lampstack-1.2-0/mysql/data/mysqld.log’.
100602 14:45:45 mysqld_safe Starting mysqld.bin daemon with databases from /home/maal11/lampstack-1.2-0/mysql/data
100602 14:45:46 mysqld_safe mysqld from pid file /home/maal11/lampstack-1.2-0/mysql/data/testpig.pid ended
/home/maal11/lampstack-1.2-0/mysql/scripts/ctl.sh : mysql could not be started

Hi,

Probably you installed the stack as “maal11” user. Try to start the servers using this user and not using the root user.

HI beltran,

When i am trying to use the mysql inside the lampstack, it is not taking the mysql inside the stack instead using the /tmp/mysql.sock, so what i did is created a soft link to the mysql inside stack(../lampstack/mysql/tmp/mysql.sock) to /tmp/mysql.sock which is working fine. but i think this is a hack and not a good procedure. So can you please specify how to make use of mysql of lampstack without this roundabout procedure of creating a lampstack. Because this soft link creation process may hamper the mysql running in the system.

I have installed LampStack in /tmp/lamp.

1. You do not have to specify the socket parameter because mysql is linked to the special wrapper which uses default mysql config /tmp/lamp/mysql/my.cnf.

$ /tmp/lamp/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

2. If you do not want to use the full path then LampStack console script will help you

$ /tmp/lamp/use_lampstack
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

or you can just modify the PATH environment variable manually:

$ export PATH=“/tmp/lamp/mysql/bin:$PATH”
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

I hope it will help.

Regards,
Danoo