Mysql.sock Gone And Mysql Restart Doesn't Create It
Jun 16, 2008For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
ADVERTISEMENT
Mysql.sock
May 6, 2007all the database in the server stop if i make a restart its giveing me that msg' :
Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
/var/tmp/mysql.sock Strange Persmissions
Nov 14, 2007I'm running a cpanel box with fedora and cannot connect to mysql from the web (Horde, phpmyadmin, java, etc...).
I looked at the permissions for mysql.sock in /var/tmp/ and this is what I found:
?--------- ? ? ? ? ? mysql.sock
I've never seen this and am wondering if this is the source of the problem?
How To Restart Mysql
Mar 16, 2007I'm on FreeBSD 6.2 dedicated server with root access control-panel Directadmin
Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.
try to do restart and after this mysql service is down too.
all my attempts to do restart aren't successful.
1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped
try to do mysql restart with this command
/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file
try to connect to mysql and get such output
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in
How To Restart Mysql
Mar 16, 2007I'm on FreeBSD 6.2 dedicated server with root access
control-panel Directadmin
Today i check that i cann't login into directadmin. at the same time ftp and ssh access are live.
try to do restart and after this mysql service is down too.
all my attempts to do restart aren't successful.
1. don't have http access to DA
2. have ftp access, but cann't overwrite files
3. have ssh access
4. mysql service is stoped
try to do mysql restart with this command
/usr/local/etc/rc.d/mysql-server.sh stop
but there isn't such file
try to connect to mysql and get such output
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2) in
Mysql Auto Restart
Dec 5, 2008Is anyone experiencing that cpanel automatically restarts mysql at 2AM?
I'm curious is that new feature or something has gone wrong?
This has started after cpanel upgrade mysql to 5.0.67 version.
I'm not so good with cpanel so please can somebody tell me where cpanel holds its crons?
I cannot find nothing in /etc/cron.* or in cron -l, and I want to turn this option off.
How To Set Up Cron Job To Restart Mysql
Nov 23, 2008How to set up cron job automatic restart mysqld at specified time. My case, mysqld will auto restart every 23 hours running.
How to set up this cron job?
Failed To Restart Mysql Service
Apr 12, 2009My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed
And when restart (by WHM )
Restarting MySQL Server
whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275
mysql has failed, please contact the sysadmin (result was "mysql has failed").
My VPS in unmanaged, i can't access mysql.
Mysql Error Message And Restart
Jun 1, 2008One of our servers mysql daemon is restarting most of the time and got the error message in the message file. Did anyone see similar error message?
Jun 1 05:46:44 kernel: audit(1212317204.342:6991): avc: denied { read } for pid=17286 comm="mysqld" name="/" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.343:6992): avc: denied { getattr } for pid=17286 comm="mysqld" path="/tmp" dev=loop0 ino=2 scontext=user_uystem_r:mysqld_t0 tcontext=system_ubject_r:file_t0 tclass=dir
Jun 1 05:46:44 kernel: audit(1212317204.346:6993): avc: denied { read } for pid=17286 comm="mysqld" name="time_zone_leap_second.frm" dev=hda2 in
Cannot Restart MySQL, HTTPD And Server
Nov 22, 2007I am not being able to restart the server, or MySQL or httpd via SSH.
PHP Code:
root@server [~]# /etc/init.d/httpd fullstatusLooking up localhostMaking HTTP connection to localhostAlert!: Unable to connect to remote host.lynx: Can't access startfile http://localhost/server-statusroot@server [~]#
PHP Code:
root@server [~]# /etc/init.d/mysql reload/etc/init.d/mysql: line 244: kill: (3375) - No such processtouch: cannot touch `/var/lib/mysql/server.lubnan.us.pid': Read-only file system
MySQL Restart On CentOS - Chown
Sep 18, 2007I have a lot of tables, being that I host multi forums. One thing I noticed when doing a mysql start up or restart is that it takes at least 15 minutes to do it. The server isn't bad, it's a Pentium D with 3GB of RAM and it runs perfectly fine. What I noticed is that after I do an SQL restart, I checked "top." The command that was running is "chown" and it sat at the top of the list, and kept going. Until finally mysql started and it stopped.
I imagine that all of the files in the data folder are being CHOWNed... and that's why it takes forever. If this is the case, how can I stop this, if at all? I don't see why they need to be CHOWNed?
Automatically Restart Mysql After High Server Load
Jan 29, 2009Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.
View 1 Replies View RelatedPlesk Automation :: MySQL Server Not Starting Anymore - Failed To Restart Service
Jun 5, 2014What could I fix by trying to start mysql server, recieve following errors:
plesk interface:
Code:
Failed to restart the "mysql" service.
Cannot start/stop/restart service: 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
from the console:
Code:
sudo service mysql start
start: Job failed to start
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
output of plesk_11.5.30_reset_instance_data.log:
[Code] ...
Mysql Cannot Create File In /tmp
Feb 3, 2008I always have this error with mysql
Can't create/write to file '/tmp/#sql_7042_0.MYI' (Errcode: 13)
the /tmp has been chmoded 1777. I installed mysql downloaded from rpm on www.mysql.com, version 5.0.51a 64bits for CentOS-5
I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working
May 8, 2009Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
How To Alter Tabel And Create Table In Mysql
Jun 24, 2009I have a script and there are some modifications that I want to make
In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.
I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.
Should I use phpmyadmin or whats the correct way?
Is It Possible To Create A Cron To Backup Mysql Data Daily
May 15, 2009Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily
mysqldump -u usernam -p password dataname > file.sql
MySQL Error: Can't Create/write To File '/dev/shm/MYxQT8lz'
May 19, 2008one of my site shows this error
MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'
I checked space on the server is still 25 GB free,
Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql
Jan 21, 2007I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
Plesk 12.x / Linux :: Enable To Create New MySQL Database Server - Test Connection Failed
May 7, 2015I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
[cpanel] "create View .." Doesn't Work For Mysql
Jul 11, 2007why this mysql command doesn't work on phpmyadmin on cpanel server.
Quote:
CREATE VIEW TEST AS SELECT * FROM COURSE
it give this error:
Quote:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VIEW TEST AS SELECT * FROM COURSE' at line 1
How To Restore Mysql Databases From /var/lib/mysql/user_database/ Files Only
Feb 11, 2008I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
Knowledge Of Mysql Exploit Or Mysql Injection?
Jan 17, 2008Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies View RelatedMySQL Monitor Shows MySQL As Offline When It's Not
Jan 15, 2007I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
Can I Move /var/lib/mysql To /home/mysql
Apr 15, 2009my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
Uninstall MySQL 3.23 And Install MySQL 5.0
Mar 28, 2007I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
Easy To Upgrade From MySQL 4.1 To MySQL 5
Jun 13, 2007I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies View RelatedMySQL Error : MySQL Server Has Gone Away
Dec 18, 2007I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
