Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2010
    Posts
    78

    Can't start mysql

    I have a linux centos vps hosting and several hours ago my site was down for an unknown reason. I couldn't access even the plesk control panel. I have contacted my hosting provider and they made some changes as it seems. Now I can access plesk but my site is still down... As far as I can figure out there are some problems with the database. I can't connect to mysql. I tried to restart mysql and the whole server as well but it didn't help. I have no idea what should I do next. It's already several hours I haven't heard anything from the hosting provider!

    Any help would be appreciated!

  2. #2
    Join Date
    Jul 2010
    Location
    ~/
    Posts
    1,382
    Anything interesting in /var/log/mysqld.log ? try to start it then 'tail /var/log/mysqld.log'
    -> INCEPTION HOSTING LIMITED Since 2010!
    -> I am most active on the lowendspirit hosting forum Come join us!
    -> PHOENIX USA & THE NETHERLANDS & UK EU

  3. #3
    Join Date
    May 2011
    Location
    New York, USA
    Posts
    4,019
    Try to reboot the vps and see what happens
    - Nexus Bytes LLC- Ryzen powered NVME VPS and web hosting, packed with perks and love!
    - Entry Bytes - Affordable VPS Cheap quality
    - USA (NYC | Miami | LA) | Europe (London, UK | Naaldwijk, NL) | Asia Pacific (Singapore | Japan | Australia)

  4. #4
    Join Date
    Feb 2010
    Posts
    78
    Here is the log from latest attempt to restart mysql (I used command "service mysqld restart" from ssh):

    110901 1:50:34 [Note] /usr/libexec/mysqld: Normal shutdown

    110901 1:50:34 [Note] /usr/libexec/mysqld: Shutdown complete

    110901 01:50:34 mysqld ended

    110901 01:50:34 mysqld started
    110901 1:50:34 [Warning] option 'innodb_additional_mem_pool_size': signed value 512000 adjusted to 524288
    InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
    InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
    InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
    InnoDB: Could not open or create data files.
    InnoDB: If you tried to add new data files, and it failed here,
    InnoDB: you should now edit innodb_data_file_path in my.cnf back
    InnoDB: to what it was, and remove the new ibdata files InnoDB created
    InnoDB: in this failed attempt. InnoDB only wrote those files full of
    InnoDB: zeros, but did not yet use them in any way. But be careful: do not
    InnoDB: remove old data files which contain your precious data!
    110901 1:50:34 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

  5. #5
    Join Date
    Jul 2010
    Location
    ~/
    Posts
    1,382
    hmm idd, is it listening on the local address? 'telnet localhost 3306' ?

    Do you have it binding to the local ip or 0.0.0.0?
    -> INCEPTION HOSTING LIMITED Since 2010!
    -> I am most active on the lowendspirit hosting forum Come join us!
    -> PHOENIX USA & THE NETHERLANDS & UK EU

  6. #6
    Join Date
    Oct 2006
    Location
    State College, PA USA
    Posts
    370
    Quote Originally Posted by levani View Post
    InnoDB: Could not open or create data files.
    InnoDB: If you tried to add new data files, and it failed here,
    InnoDB: you should now edit innodb_data_file_path in my.cnf back
    Pretty sure that's a permissions error. Check the perms on that folder and make sure that the user trying to start mysql has perms to write the innodb files. If not, start via sudo.

    Best,
    Dave
    Cheap VPS Hosting with minimum 99.9% SLA.
    State College, PA VPS Hosting

  7. #7
    Join Date
    Apr 2009
    Location
    inside wht
    Posts
    746
    Please check Dave's suggestion . Check the /var/lib/mysql/ folder and see what permissions and ownerships the databases and ibdata files have.
    24x7 PROACTIVE SERVER MANAGEMENT | OUTSOURCED WEB HOSTING SUPPORT
    Sales : sales @ syslint.com | Call us : (+91)9447607799 | Are you looking for DevOps Admins ?

  8. #8
    Join Date
    Jun 2011
    Location
    Woodbridge, NJ
    Posts
    840
    Yup, permissions problem.

    Verify that the user & group MySQL is running under (in most cases both are 'mysql') have permissions to read and write files in /var/lib/mysql.

    If not, run these commands (assuming that the MySQL user and group are both 'mysql'):

    Code:
    sudo chown -R mysql:mysql /var/lib/mysql/ib*
    sudo chmod -R 660 /var/lib/mysql/ib*

  9. #9
    Join Date
    Jun 2011
    Location
    Woodbridge, NJ
    Posts
    840
    If that still doesn't work, check /etc/my.cnf for the value of innodb_data_file_path. That is where MySQL is attempting to write to.

Similar Threads

  1. MySQL Cannot Start
    By M Nour in forum Dedicated Server
    Replies: 11
    Last Post: 11-01-2010, 05:00 AM
  2. Cannot get MYSQL to start
    By Matt Holme in forum Hosting Security and Technology
    Replies: 3
    Last Post: 12-15-2006, 01:27 PM
  3. Where do you start with mySQL?
    By Cath in forum Programming Discussion
    Replies: 3
    Last Post: 07-28-2004, 07:33 AM
  4. RaQ550 and MySQL - MySQL will not start
    By BooBoo in forum Dedicated Server
    Replies: 19
    Last Post: 03-08-2003, 07:11 AM
  5. how to get mysql to start again
    By enrique in forum Dedicated Server
    Replies: 6
    Last Post: 01-21-2002, 01:05 PM

Tags for this Thread

Posting Permissions

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