starting mysql

English Applications
1

good day.

i am trying to use the mysql. i installed the mysql using the yast. the installation has no problem. then i opened up the database administration gui. tried to connect localhost with user root and corresponding password. but there is a error:

Could not connect to host ‘localhost’.
MySQL Error Nr. 2002
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)

Click the ‘Ping’ button to see if there is a networking problem.

i typed in chkconfig at the command, the mysql is set to off. hoq do i turn on the mysql? thanks.

2

From YaST also, under services.

Or if you prefer, from the CLI, only needed this time, in future it will start at boot.


chkconfig --set mysql on
rcmysql start
3

thanks sir ken_yap. i go the sql starting. im not really an expert in using linux command line, im more comfortable using the gui so ill experiment on the mysql using the database administration gui.

chkconfig --set mysql on << does this command automatically runs the mysql on restart of the pc?

4

Yup.

(Extra words to make message more than 10 characters, or forum software will not take it. :slight_smile:

5

ok thanks so much sir. till next time. have a nice day.