CentOS 5 Server :: Mysql (mysqld) Not Loading Config File?
Apr 30, 2009
We have been struggling with a problem with the mysql-server package. This might be in the wrong category because our problems are with it on x86_64. Where the problem happens variables that should populate from the my.cnf don't, on other servers, they do, the my.cnf files are identical except for the server-id
The problem occurs on some of our machines but not others. All are using the mysql-server-5.0.45-7.el5.x86_64 The ones that work, when you connect with a client respond with server version 5.0.45-log source distribution The ones that don't work respond with 5.0.45 source distribution
It's unclear what the differences are between the two source versions and how we wind up with two different versions. One thing that might be involved, the mysql package is installed with both the i386 and x86_64
View 1 Replies
ADVERTISEMENT
Apr 10, 2010
After the upgrade from 8.10 to 9.04, all was well. But after the upgrade from 9.04 to 9.10, I lost the MySQL server. Now, I recall during the upgrade, I was asked if I wanted to keep the existing my.cnf file or replace it with a newer one. I did as suggested and kept the original as I had edited it before. The same question was asked with a couple other config files. I kept the original in each case. After the first step, I checked the server was running and the websites were up, all was well. After the update to 9.10, when I checked the server, I get the following error:
Code: 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! Can anyone point me in the right direction to getting this resolved?
View 2 Replies
View Related
Apr 18, 2011
i have successfully installed mysql server but when i am try to create database, it shows error like this
ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)
** mysqld is not available in /var/run and error log file is also not available in /var/log **
View 4 Replies
View Related
Feb 24, 2011
I need some help.Trying to set up bugzilla on my VM.After setting up the IP to use static i could log on to the url its not even loading up from command line its issueing an error.when i try to log on to mysql
bugzilla:~# mysql -u root mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
View 1 Replies
View Related
Feb 27, 2011
I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:
Code:
root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock
[code].....
View 4 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Apr 18, 2011
installing mysql server manually. i have successfully installed mysql server but when i am try to create database, it shows error like this
ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)
** mysqld is not available in /var/run and error log file is also not available in /var/log **
View 5 Replies
View Related
Feb 16, 2010
I'm trying to change some configurations but when I change it from the default options in main.cf, it doesn't actually update the running configuration. I've even restarted the server all together but it still doesn't update it.In main.cf, here is the configuration I've added:
bounce_template_file = /etc/postfix/bounce.cf
bounce_queue_lifetime = 4h
maximal_queue_lifetime = 4h
delay_warning_time = 1h
View 1 Replies
View Related
Oct 8, 2010
I am running CentOS 5.2 with php5.3 and Mysql. I am running a CRM program called Sugar on the server and I am having a problem where the webpages don't always load correctly. I am not sure if this is something on the program itself or if there is a problem some or other setting on the webserver. I am accessing the server over a local network so I don't think it is connection issues. The server has a static IP.
View 10 Replies
View Related
May 23, 2010
My server is using MySQl mysql-5.0.77-3.el5 on Centos 5.4.When I check mysql log at /var/log/mysqld.log,it displays warning Quote:
100524 11:46:21 mysqld started
100524 11:46:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
100524 11:46:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
[code]....
View 7 Replies
View Related
May 2, 2011
when installing mysql-server by this command sudo apt-get install mysql-server. Installaton is complete but i cant get a my.cnf file. Can anyone tell, what is the mistake i did and how to overcome from this error. Here, i am posting the results
sam-osm@dhcppc4:~$ sudo nano /etc/mysql/
conf.d/ debian.cnf
View 2 Replies
View Related
Apr 2, 2009
I've installed the CentOS 5.1 from a CD only yesterday and everything is working fine except Mysql that came from the CD distribution. I have detected that my system has mysql.
[root@onion /]# rpm -qa |grep mysql
mysql-5.0.22-2.1.0.1
[root@onion /]# find . -name mysql
./usr/bin/mysql
./usr/share/mysql
./usr/lib/mysql
However I'm unable to find mysqld, safe_mysqld or mysql_install_db in my filesysytem.
[Code]...
View 3 Replies
View Related
May 5, 2011
i'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
View 6 Replies
View Related
Jun 9, 2011
I managed to successfully install LAMP on my VPS and proceeded to install Wordpress only to run into an odd error.When I click on index.php, it starts to load but nothing happens.
The details:
LAMP = CentOS5.5, Apache 2.2.18(compiled from source), MySQL 5.1.57(compiled from source), PHP 5.3.6(from source too) My site: ottomatic.org as you can see in the index of files index.php is what I'm trying to load and if you check phpinfo.php you can see that PHP was installed correctly too. I added an .htaccess file with 644 permissions to my web root directory and that only seemed to produce an error, this is what I put in the .htaccess:
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
[Code]...
View 6 Replies
View Related
Mar 28, 2009
I have recently installed MySQL Server on my CentOS box.
CentOS 5 MySQL 5.0.45 (installed using 'yum install mysql-server') I can start the daemon without error by issueing the following command: service mysqld start
The problem is that I want to use a number of the command line options available to mysqld, such as --verbose and When I issue '/etc/init.d/mysqld --verbose --help' I get the following output:
[Code]...
View 1 Replies
View Related
Sep 7, 2009
I was tryin to deploy svn on centos 5 with respect to [URL] I am stuck understandin the location svnpath parameter on svn config
[Code]...
View 1 Replies
View Related
Feb 15, 2011
Starting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
View 6 Replies
View Related
Feb 1, 2009
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
View 11 Replies
View Related
Apr 26, 2010
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
View 9 Replies
View Related
Dec 27, 2010
Can anyone tell me what command can be used so that the Linux Centos Server starts mysqld, httpd and ftpd services at boot time automatically?
View 2 Replies
View Related
Jul 8, 2010
I was playing with the mysql my.cnf file yesterday, trying to move my database files to my dropbox folder so I can use the database on my other machine. All I changed was the datadir setting to point to my dropbox folder. I also moved my mysql data files there.
When I tried to restart mysql and test the new location it said my mysqld.sock was missing. I searched and searched the web and my filing system for it but I have no idea what's happened to it?? I have even tried changing the datadir path back and reinstalling mysql but that doesn't seem to work either.
View 2 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related
Mar 3, 2009
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).
[Code]...
View 16 Replies
View Related
Jul 14, 2010
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.
View 4 Replies
View Related
May 21, 2009
For security reasons I need to ensure all of my users screensaver is set to come on after 10 minutes of inactivity. My thought was to find the screensaver config file, modify a setting in the file to 10 minutes and change ownership of the file to be root (so the user can't undo my changes either in the file or via the gui). However, I can't find the screensaver config file to do this. I'm running Centos 5.2. Anyone know where I can find the screensaver config file?
View 2 Replies
View Related
Jan 17, 2010
i have a VPS server running centOS 5 and i need to edit the boot loader config file but my VPS does not seem to have the usual suspects of grub.conf or lilo any where on the system.
where the boot loader config file might be or what it might be called ?
If it helps to know, the VPS was setup instantly the moment i bought it.
View 1 Replies
View Related
Oct 21, 2009
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
[Code]...
View 2 Replies
View Related
Aug 8, 2011
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)
View 2 Replies
View Related
Jun 15, 2011
I tried to installed Centos5.4 version on Dell PC intel corei3 inspiron580s and succeeded but found some issues following below
1 Hardware issue for LAN driver ( Broadcomlink(TM)gigabit ethernet)
2 Display Driver not support and also missing Xorg.config file (i.e ., My Screen Starts from center of screen )
3. What is minimum configuration for centos 5.4 ?
View 2 Replies
View Related
May 26, 2010
I did a yum update this morning that included a dnsmasq update. Subsequently, for an unrelated reason, I restarted dnsmasq, but it failed because /etc/dnsmasq.d didn't exist. It looks like my /etc/dnsmasq.conf file now includes "conf-dir=/etc/dnsmasq.d" at the end. Since dnsmasq was starting and I didn't remove dnsmasq.d, I assume this line was added by the update. Commenting the line resolves the issue.
An alternative hypothesis, given that I don't really know what the state of /etc/dnsmasq.conf and /etc/dnsmasq.d/ was before the update, might be that the directory did exist, but was removed by the update. I find this the least likely of my 2 stated hypotheses. (There are other hypotheses, but I think they are even less likely). Am I correct is concluding the conf-dir line was added by the update? If so, shouldn't the updated RPM create the directory during install?
View 6 Replies
View Related
