I have a VPS running on centos-5-x86 and mysql server went down two days ago this is my mysql server log
110602 18:28:09 mysqld started InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 110602 18:28:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery.
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld] datadir=/var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package).
I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql: ^G/usr/bin/mysqladmin: connect to
Been working with this problem for over a week now and has come to a dead end, I have installed pureFTPD with MySQL on Debian 5 Lenny 64bit. My problem is I can't login with the users in the sql-database, but for some strange reason, I'm allowed to loggin as anonymous. Unix users can't login either.
I have followed the guide on: [URL]..
- Created a ftpgroup and ftpuser. - Created a database ftpd - Created a user vhosts and given access to ftpd db My configurations files /etc/pure-ftpd/auth/30mysql Code: /etc/pure-ftpd/db/mysql.conf /etc/pure-ftpd/db/mysql.conf
Alright, so I installed the c5-testing versions of httpd, php, and mysql, since my server is used for other daemons primarily and these aren't used as production servers I decided to test the bleeding edge versions of these, report any bugs I find, etc. The problem is, since I updated httpd and mysqld they no longer start up at boot. I tried using chkconfig --add with both of them, but both their init.d scripts have - for levels, so I did not assign any levels. They still do not start up at boot. [URL]
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
I installed LaMp 2 days ago. First everything works; But until yesterday, I can't start anymore mysql server : it failed each time.
When I look at the status :
Code: Select allsystemctl status mysql Failed to get D-Bus connection: Erreur inconnue -1
It's like it can't generate mysqld.sock
Code: Select all/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
I keep reading man and trying to find something I didn't configure correctly, but I can't find nothing.
i am using putty to connect to my server and wanted to restart mysql server. searched the internet and found thatcommand is /etc/init.d/mysqld start or stopbut it did not worked.then tried /etc/init.d/mysql stop or startthis also did not worked.
XAMPP: Couldn't start MySQL! I have Ubuntu 11.4. After downloading XAMPP, I went to my Downloads. I then went to the Folder (xampp-linux-1.7.4.tar.gz) and right clicked on it. The options window opened, and I selected "Extract Here"! after doing so a Folder called lampp appeared. The next step I did was open my Terminal and typed ( sudo nautilus / ). I pressed Enter and a window with a bunch Folders opened up. I selected, and opened the opt Folder. I then dragged the lampp Folder to the opt Folder.
The lampp Folder is now in the opt Folder. I right clicked on the lampp Folder and selected Properties, and then the Permissions tap. I set all 3 Folder access: -to- Create delete files and all 3 File access: -to- Read and write. I checked Allow executing file as program, and Apply Permissions to Enclosed Files button, then closed. I went back to Terminal and typed (sudo /opt/lampp/lampp start) and pressed Enter. Everything is working fine execpt MySQL!
Starting XAMPP for Linux 1.7.4... XAMPP: Starting Apache with SSL (and PHP5)... XAMPP: Starting MySQL... XAMPP: Couldn't start MySQL! XAMPP: Starting ProFTPD... XAMPP for Linux started.
I don't know if it makes any difference but I do have Netbeans IDE 7.0 php installed and I've only worked on html and CSS on it.
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Since upgrading from Wheezy to Jessie I have not been able to start the MySQL-server. When I do a "systemctl start mysql" I get the following answer on the console:
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. Entering 'systemctl status mysql.service' the answer is: ● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql) Active: failed (Result: exit-code) since Don 2015-06-18 18:35:41 CEST; 4min 1s ago Process: 11272 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
syslog and hostname.err don't show any pertinent messages.
I tried to install php from source file on centos server and i got the error as # ./configure --with-apxs2=/usr/local/packages/apache/bin/apxs --with-mysql --prefix=/usr/local/packages/apache/php --enable-force-cgi-redirect --disable-cgi --with-zlib --with-gettext --with-gdbm
checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.
I'm configuring a new Centos 5.5 server in replacement of an old W2K server.The topology of our network is simple : one file/dhcp/dns relay server and workstations (PC's and some MAC's) plus network printers and scanners.All the workstations have dynamic IP addresses (easier because a lot of 'dynamic' changes : new persons with their own laptop, ...) and the server and printers/scanners have fixed IP addresses.I edited the dhcpd.conf (see here underneath), I have the file dhcpd.leases but it doesn't start !
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory