Blog Archives

Remote access to mysql database

Step 1 : vi  /etc/my.cnf ——————————————— pid-file        = /var/run/mysqld/mysqld.pid socket          = /var/run/mysqld/mysqld.sock port            = 3306 basedir         = /usr datadir         = /var/lib/mysql tmpdir          = /tmp language        = /usr/share/mysql/English bind-address    = mysql server ip # skip-networking ——————————————— bind-address : IP address to

Posted in Issues, Mysql, Server Setup

mysql showing wrong version on cpanel

edit /home/username/.cpanel-datastore/_usr_sbin_mysqld_–version if you have multiple accounts with problem find ./*/.cpanel-datastore/ | grep _usr_sbin_mysqld_–version | awk ‘{system (“rm ” $1)}’

Posted in Issues, Mysql, Scripts

mysql error = cant connect to mysql socket via /var/lib/mysql

cd /var/lib/mysql touch mysql.sock chown mysql:mysql mysql.sock chmod 777 mysql.sock ln -s /var/lib/mysql/mysql.sock /tmp chmod 777 /tmp /scripts/mysqlup –force /etc/rc.d/init.d/mysql restart

Posted in Mysql

Mysql database restore

mysql backup: var/lib/mysql#mysqldump xx > xx.sql mysql restore: var/lib/mysql#mysql xx < xx.sql

Posted in Mysql
Blog Stats
  • 111,920 hits
Follow

Get every new post delivered to your Inbox.

Join 209 other followers