On my squeeze installation, when I shutdown my computer, there is an error message saying that "...cannot shutdown mysqld". I ignored it and there does not seem to have any ill effect.
edit: here is the exact message: "Stopping msql-server: mysqld failed"
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 **
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?
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)
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].....
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 **
i have fresh installed debian wheezy xfce4, and using slim to start it but i can't get reboot, shutdown and thunar can't open flash and others volumes. i using .xinitrc (exec ck-launch-session startxfce4)
View 3 Replies View RelatedI have installed a cluster computer with 10 nodes . The manufacturer is HP . All nodes and the master node have redhat enterprise linux installed in them . When I shutdown the nodes from the master terminal using "shutdown -h now" they get shutdown . But they dont get completely turned off . This issue bothers me when the power supply is given , all nodes boot up simultaneously generating a huge heat .
Thing to note : When we shutdown our PC they get completely turned off . When the power supply is given , a press on the Power On button is required to boot the system. But , why does it not happpen in the case of cluster? Is there any other way of completely turning off the nodes from the master terminal ?
I need to test an application on a Ubuntu Server that works as a database server for the network.
On this server's /etc/mysql/my.cnf, I have:
Code:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = <server-ip-address>
This means that I can't access the mysql server from 127.0.0.1, right?
I tried adding the following entry to /etc/hosts.allow :
Code:
mysqld : 127.0.0.1 : allow
I feel like I need to restart the service that reads /etc/hosts.allow, is this approach correct?
Or on /etc/mysql/my.cnf I can have two (or more) bind-addresses entries?
In my office we sometimes have servers that hit the max_connections limit. As we sometimes have scripts that take up that 1 extra 'superuser' slot for MySQLD, we'd like to raise that. Google really hasn't turned up much on this, is there a way to raise the number of slots?
View 1 Replies View Relatedas soon as mysqld starts it goes 100% cpu. I can stop it, there is no mysql_safe running, and I ran mysqlcheck -A -a -c -o -g --auto-repair -u root -p all is ok, syslog shows nothing important but I can't login to any account with mysql client it just sits there, using php it times out. I don't know how to fix the urgent situation...
Looks like it has been started after a release update to 9.10 or 10.4 (i did it in a row) I don't know if this bug is related [URL]
I have a virtual machine (VirtualBox) with Ubuntu 9.10 installed, I'm trying to install MySql community editor using the linux-generic package (the tar package), I followed all the procedure but I had a problem with the next line of code:
shell> scripts/mysql_install_db --user=mysql
I don't understand a lot about the command line, but I think this line of code is used to create the basic tables of the database (users and so on). the problem I got with this line of code is:
FATAL ERROR: Could not find mysqld
I googled it and after a while I found this blog:
azimbabu.blogspot.com/2009/07/mysql-5136-in-ubuntu-904-fatal-error.html
The blog says that the problem is a default instalation of SQL, and the solution is replace the file my.cnf in the location /etc/mysql for other file that comes with the package.
I didn't replace the file my.cnf, I only changed the name and it woked perfectly, and this is the problem, I don't understand why it worked.
Any one knows why this file is so important?What could happen if I delete this file?what is the purpose of the package mysql-common un Ubuntu?
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]....
I tried to stop mysqld deamon. It failed
Code:
[zabbix@CDCTGIMCLSA ~]$ sudo /etc/init.d/mysqld stop
Stopping MySQL: [FAILED]
[code]....
We are using wordpress with MYSQL. Both the app and DB server are different with 6CPU and 6GB RAM and 32bit processor. We had noticed recently that mysqld process is taking too much of system usage- ranging upto 100% of CPU utilization while having the load of 1200-1600 concurrent users.
Pasting d my.cnf file-
# The following options will be passed to all MySQL clients
[client]
port= 3306
[code]....
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]....
I have 4 servers:
- One is loadbalancer, installed keepalived and ipvsadm - LV1
- One is failover for loadbalancer, installed keepalived and ipvsadm too - LV2
- The other servers was installed httpd and mysqld. (RealServer)
LV1 load balancing for both httpd and mysql. And it's working fine.
VIP for http: 192.168.1.110
VIP for mysql: 192.168.1.111
Now I want to setup a website on RealServers , with URL is [url], and this website connect to mysql via VIP 192.168.1.111, this means real servers will connect to their mysql via load balancer (LV!). I tried to connect mysql via VIP from real server but it cannot.
I installed mysqld with yum then yum quit working with this error:http://yum.baseurl.org/ticket/70 when mysqld is stopped yum works again. what does a running instance of mysqld have in common with a python yum package manager?
rpm -qa rpm* python* yum* mysql* | sort
mysql-5.0.45-7.el5
mysql-devel-5.0.45-7.el5
mysql-server-5.0.45-7.el5
[Code]...
I searched the forum for this, but didn't find anything about it: when I try to shut down the computer, it returns to the login screen. When I log back in and shutdown again, it shuts down.Squeeze works perfectly, but this is the only thing that doesn't work like it should. Is this a setting I should change somewhere?
View 6 Replies View RelatedWorking with 8.2 DVD installation for about 5 days, Debian newbie. As subject says, screen goes dark and hangs indefinitely.
This guide: [URL]... similar to others I've read. I've done everything there to section: Status and Logs of Services, and that's as far as I've gotten.
Guide suggested posting some files, so here they are:
Code: Select all#
# Grub.cfg
#
# DO NOT EDIT THIS FILE
#
# It is automatically generated by grub-mkconfig using templates
# from /etc/grub.d and settings from /etc/default/grub
#
[Code] ....
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 RelatedI'm running Ubuntu 8.04.4 LTS to host a moodle server in a school.. moodle is running OK - but I'm having problems with MySql Any mysql command generates:
unknown variable 'pid-file=/var/run/mysqld/mysqld.pid'
I've taken a look in unknown variable 'pid-file=/var/run/mysqld/ and there is no mysqld.pid file I have followed these instructions that I found elsewhere:
If there�s no mysqld.pid inside /var/run/mysqld directory, create mysqld.pid
# cd /var/run/mysqld
# touch mysqld.pid
[code]....
But after reboot the mysqld.pid file is missing again.. I can access mysql via phpmyadmin - but webmin fails with unknown variable 'pid-file=/var/run/mysqld/mysqld.pid'
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!!!
I have Centos 5.1 and im a total newbie. I have managed to get it running with Apache and PHP but after I install mysql it fails to start with the above error. I have removed it as well using YUM and reinstalled it but it still will not start.
View 4 Replies View RelatedI 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]...
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
Recently I installed vncserver (tigervnc) on my desktop. Ever since my computer refuses to shutdown normally. At shutdown the following message pops up: Quote: System policy prevents stopping the system when other users are logged in Then I have to enter the root password to shutdown. If I stop vncserver before, the computer shuts down normally.
[Code]....
when my pc boots and shuts down my monitor goes into 'input out of range' mode for a bit between the gui and the text only phases of boot/shutdown.is there a way to fix this? or where to start troubleshooting?also, when it shuts down it hangs after coming back to the text only part
View 4 Replies View RelatedIs it possible to shutdown or to halt by means of cron ? this crontab entry is doing nothing: 45 3 * * * halt
View 2 Replies View RelatedI search many hours on the web for wipe my ram in a secure way and i find nothing good/secure/work exept URL... and i think it's the best solution for wipe RAM at shutdown!Im a newbie user and i want to implement this solution on my debian system at shutdown, i think its very easy because TAILS is based on debian! Does someone can put the procedures for get that on a debian box please?
View 8 Replies View Related