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

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:

CODE
[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-

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

168.lower-test
/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!
lampshade
Made some progress this morning running the following command in '/':

CODE
/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:

CODE
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?
michaelk
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.

lampshade
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: amazon.com/aws
michaelk
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


cyberciti.biz/faq/find-linux-distribution-name-version-number/
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-2017 Invision Power Services, Inc.