Results 1 to 3 of 3

Thread: mysql error after rebooting

  1. #1
    Join Date
    Jul 2012
    Location
    Elmira, NY
    Beans
    162
    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.
    Ubuntu 13.04, x86_64, 3.8.0-19-generic, gnome3 desktop, multi-boot
    Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 8GB RAM, dual monitors, AMD Radeon HD 6770
    Python 3.2.3 and 2.7.3, tkinter 8.5, pyqt 4.8.1, pygame 1.9.2 pre
    https://github.com/metulburr

  2. #2
    Join Date
    Nov 2010
    Location
    India
    Beans
    4,847
    Distro
    Ubuntu Development Release

    Re: mysql error after rebooting

    ok try this
    Code:
    sudo  service mysql stop
    Google First your issue , if no solution then ask.

    రాజ శేఖర్ రెడ్డి

  3. #3
    Join Date
    Jul 2012
    Location
    Elmira, NY
    Beans
    162
    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
    Ubuntu 13.04, x86_64, 3.8.0-19-generic, gnome3 desktop, multi-boot
    Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 8GB RAM, dual monitors, AMD Radeon HD 6770
    Python 3.2.3 and 2.7.3, tkinter 8.5, pyqt 4.8.1, pygame 1.9.2 pre
    https://github.com/metulburr

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
  •