Posted By: palwatcher on January 19, 2015, 4:21 am
Hello,
I have installed and can run AMPPS on my Ubuntu 12 machine - but I cannot get mysql to start. Apache starts but when I click start for mysql it tries and then revert back to off.
I am a rookie with a bit of knowledge (enough to gt me in trouble) but am stuck.
Ideas?
Thanks!
pete
Posted By: Rishi_P on January 20, 2015, 10:49 am | Post: 1
Hi,
open your terminal and run below command.
/usr/local/ampps/mysql/bin/mysqld
Please let us know the output.
Posted By: palwatcher on January 20, 2015, 8:40 pm | Post: 2
Thank you.
Here is what I ran:
:~$ /usr/local/ampps/mysql/bin/mysqld
Here is what came up:
2015-01-20 14:29:56 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-01-20 14:29:56 2387 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
2015-01-20 14:29:56 2387 [Warning] Can't create test file /usr/local/ampps/var/peter-Inspiron-8600.lower-test
2015-01-20 14:29:56 2387 [Warning] Can't create test file /usr/local/ampps/var/peter-Inspiron-8600.lower-test
2015-01-20 14:29:56 2387 [Warning] lower_case_table_names was set to 2, even though your the file system '/usr/local/ampps/var/' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems.
2015-01-20 14:29:56 2387 [Warning] One can only use the --user switch if running as root
Posted By: Rishi_P on January 21, 2015, 7:07 am | Post: 3
Posted By: palwatcher on January 21, 2015, 5:28 pm | Post: 4
Thanks for the reply. This is what I did:
opened the my.conf file located in /etc/mysql under sudo and edited the line you stated as written in gedit.
Opened and started Apache then MySQL. Apache still starts but MySQL does not.
When I do start Ampps from Terminal I get this (and I did before as well):
QSslSocket: cannot resolve SSLv2_client_method
QSslSocket: cannot resolve SSLv2_server_method
I did run this:
mysql --help --verbose
to find where the order of conf files was. Thats was how I found the one that had the line to edit.
I reran your command and ended up with the same as before:
/$ /usr/local/ampps/mysql/bin/mysqld
2015-01-21 11:13:35 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2015-01-21 11:13:35 9910 [ERROR] Can't find messagefile '/Applications/AMPPS/mysql/share/english/errmsg.sys'
2015-01-21 11:13:35 9910 [Warning] Can't create test file /usr/local/ampps/var/peter-Inspiron-8600.lower-test
2015-01-21 11:13:35 9910 [Warning] Can't create test file /usr/local/ampps/var/peter-Inspiron-8600.lower-test
2015-01-21 11:13:35 9910 [Warning] lower_case_table_names was set to 2, even though your the file system '/usr/local/ampps/var/' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems.
2015-01-21 11:13:35 9910 [Warning] One can only use the --user switch if running as root
Any more thoughts? Thank you so far.
Posted By: palwatcher on January 21, 2015, 5:39 pm | Post: 5
Wait!!
So I just spent another minute looking at "what" you were asking me to do instead of the "how" to do it. I looked into the file structure you had me type and it doesn't exist on my setup, but I could find where you were leading me to with a different path. Namely /usr/local/ampps/mysql/share and there were the language files.
So I used that path and it seems to be working out just fine. I'll keep you posted if it changes.
Thank you again.
Posted By: Rishi_P on January 21, 2015, 5:53 pm | Post: 6
Hi
sorry for wrong path /Application/AMPPS is for MAC OS X and /usr/local/ampps is for linux.
I forgot that you are using linux and gave you Mac OS path. But i am glad your problem is solved now. Please let me know if you need any further information.