Help - Search - Members - Calendar
Full Version: Starting MySQL under Linux
Linuxhelp > Support > Programming in Linux

What is the command to start MySQL service under Linux OS?

I installed MySQL under the '/' directory as: 'mysql-5.6.19-linux-glibc2.5-x86_64'. I navigate to the bin directory as I do under Windows7 and try to start mysqld - if its anything like Win7 (which it is probably not) then I need to run mysqld first.

I eventually tried:

/bin/mysqld start

and received:

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --

explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-28 09:02:07 1643 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
2014-06-28 09:02:07 1643 [Warning] Can't create test file /usr/local/mysql/data/ip-10-170-70-

2014-06-28 09:02:07 1643 [Warning] Can't create test file /usr/local/mysql/data/ip-10-170-70-

/mysql-5.6.19-linux-glibc2.5-x86_64/bin/mysqld: Can't change dir to '/usr/local/mysql/data/'

(Errcode: 2 - No such file or directory)
2014-06-28 09:02:07 1643 [ERROR] Aborting

2014-06-28 09:02:07 1643 [Note] Binlog end
2014-06-28 09:02:07 1643 [Note]

Please help!
Made some progress this morning running the following command in '/':

/mysql-5.6.19-linux-glibc2.5-x86_64/bin/mysql -u root -p

MySQL prompts me asking for a password, I just hit the carriage return and find its response:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

My guess is that I need to open the database socket, 3306?
What distribution/version are you running and how did you install mysql?

So mysqld is the server and mysql is the command line client. If the server started successfully then port 3306 would be open and the client could connect.

I installed MySQL using wget [shortcut] and then unzipped it. Again, its installed under the '/' directory.

As for the distribution version, I really don't know. Its a LinuxAMI free tier, please see:
Look at the link below to see if you can determine the distribution/version. It would be best to use the distribution package manager since it will install the program and any necessary dependencies. In addition the program will be already configured so you do not have to do anything.

I might assume that it is already installed and might guess you are running CentOS so try (as root)
service mysqld start
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2018 Invision Power Services, Inc.