Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Mysql won't start on ubuntu



Threaded Mode | Print  

 Mysql won't start on ubuntu (6 Replies, Read 7927 times)
palwatcher
Group: Member
Post Group: Newbie
Posts: 5
Status:
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
IP: --   

Mysql won't start on ubuntu
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Hi,

open your terminal and run below command.
/usr/local/ampps/mysql/bin/mysqld

Please let us know the output.
IP: --   

Mysql won't start on ubuntu
palwatcher
Group: Member
Post Group: Newbie
Posts: 5
Status:
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

IP: --   

Mysql won't start on ubuntu
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
Hi,

open your mysql configuration
find this line

lc-message-dir=

and change it to

lc-messages-dir=/Applications/AMPPS/mysql/share/english



Edited by Rishi_P : January 21, 2015, 7:08 am
IP: --   

Mysql won't start on ubuntu
palwatcher
Group: Member
Post Group: Newbie
Posts: 5
Status:
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.
IP: --   

Mysql won't start on ubuntu
palwatcher
Group: Member
Post Group: Newbie
Posts: 5
Status:
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.
IP: --   

Mysql won't start on ubuntu
Rishi_P
Group: Member
Post Group: Elite Member
Posts: 317
Status:
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.

Edited by Rishi_P : January 21, 2015, 6:02 pm
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 9:06 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.096