Results 1 to 3 of 3

Thread: mysql error after rebooting

  1. #1
    Join Date
    Jul 2012
    Location
    Elmira, NY
    Beans
    264
    Distro
    Ubuntu 14.04 Trusty Tahr

    [SOLVED] mysql error after rebooting

    I had some weird things happen, that i figured needed a reboot.

    After I rebooted I went to my forums to find this error msg:
    Code:
    MyBB has experienced an internal SQL error and cannot continue.
    
    SQL Error:
    2002 - Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Query:
    [READ] Unable to connect to MySQL server

    after this i tried to start/stop/restart mysql server:
    Code:
    metulburr@ubuntu:~$ sudo /etc/init.d/mysql restart
    Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql restart
    
    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the stop(8) and then start(8) utilities,
    e.g. stop mysql ; start mysql. The restart(8) utility is also available.
    start: Job failed to start
    metulburr@ubuntu:~$ sudo /etc/init.d/mysql stop
    Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql stop
    
    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the stop(8) utility, e.g. stop mysql
    metulburr@ubuntu:~$ mysq
    No command 'mysq' found, did you mean:
     Command 'mysql' from package 'mysql-client-core-5.5' (main)
    mysq: command not found
    metulburr@ubuntu:~$ /bin/mysq
    bash: /bin/mysq: No such file or directory
    metulburr@ubuntu:~$ /bin/mysql
    bash: /bin/mysql: No such file or directory
    metulburr@ubuntu:~$ sudo /etc/init.d/mysql start
    Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql start
    
    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the start(8) utility, e.g. start mysql
    start: Job failed to start
    metulburr@ubuntu:~$ service mysql start
    start: Rejected send message, 1 matched rules; type="method_call", sender=":1.68" (uid=1000 pid=4282 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")
    metulburr@ubuntu:~$ start mysql
    start: Rejected send message, 1 matched rules; type="method_call", sender=":1.69" (uid=1000 pid=4293 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")
    metulburr@ubuntu:~$ mysql start
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    metulburr@ubuntu:~$
    I see the error msgs, but not sure what to do about it?
    Last edited by micahpage; October 3rd, 2012 at 03:14 PM.

  2. #2
    Join Date
    Nov 2010
    Location
    India
    Beans
    Hidden!

    Re: mysql error after rebooting

    ok try this
    Code:
    sudo  service mysql stop
    Dont miss anything even it is small. one small pin is enough to bring down a man.


  3. #3
    Join Date
    Jul 2012
    Location
    Elmira, NY
    Beans
    264
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: mysql error after rebooting

    yeah i did that: i got an error



    OK i figured it out. My inet addr changed when i rebooted, and i reset router for port forwards to the correct inet addr, but i didn't know that this file still had the old inet addr in it. which cause a lot of headaches


    in file:
    Code:
    /etc/mysql/my.cnf
    i ahd to change to the new inet address:
    Code:
    bind-address		= 192.168.1.7

Bookmarks

Posting Permissions

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