Results 1 to 5 of 5

Thread: starting mysql

  1. #1

    Default starting mysql

    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. #2
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: starting mysql

    From YaST also, under services.

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

    Code:
    chkconfig --set mysql on
    rcmysql start

  3. #3

    Default Re: starting mysql

    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. #4
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: starting mysql

    Yup.

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

  5. #5

    Default Re: starting mysql

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •