Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Starting MySQL under Linux
lampshade
post Jun 28 2014, 04:11 AM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 3
Joined: 28-June 14
Member No.: 18,759



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!
Go to the top of the page
 
+Quote Post
lampshade
post Jun 28 2014, 10:15 AM
Post #2


Whats this Lie-nix Thing?
*

Group: Members
Posts: 3
Joined: 28-June 14
Member No.: 18,759



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?
Go to the top of the page
 
+Quote Post
michaelk
post Jun 28 2014, 11:28 AM
Post #3


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,800
Joined: 23-January 03
Member No.: 360



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.

Go to the top of the page
 
+Quote Post
lampshade
post Jun 28 2014, 12:45 PM
Post #4


Whats this Lie-nix Thing?
*

Group: Members
Posts: 3
Joined: 28-June 14
Member No.: 18,759



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
Go to the top of the page
 
+Quote Post
michaelk
post Jun 28 2014, 01:46 PM
Post #5


Its GNU/Linuxhelp.net
*******

Group: Support Specialist
Posts: 1,800
Joined: 23-January 03
Member No.: 360



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/
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 16th December 2017 - 02:25 AM