Printable Version of Topic

Click here to view this topic in its original format

Linuxhelp _ Programming in Linux _ Starting MySQL under Linux

Posted by: lampshade Jun 28 2014, 04:11 AM

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!

Posted by: lampshade Jun 28 2014, 10:15 AM

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?

Posted by: michaelk Jun 28 2014, 11:28 AM

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.


Posted by: lampshade Jun 28 2014, 12:45 PM

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

Posted by: michaelk Jun 28 2014, 01:46 PM

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/

Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)