mysql logs
MySQL General Information and Errors : Location : /var/lib/mysql/$(hostname).err Description [...]
Mysql Database Dumb n Restore
Creation of database In Mysql Prompt > create database <databasename>; [...]
Mysql Password
In cpanel Login WHM ---> mysql root password --> Given [...]
Mysql login ‘n’ privilages
login to mysql as admin user mysql -u admin -p`cat [...]
Mysql -Important Locations
/etc/my.cnf /var/run/mysqld/mysqld.pid /var/lib/mysql /var/run/mysqld/mysqld.sock /home/username/.cpanel-datastore/_usr_sbin_mysqld_–version /scripts/mysqlup –force /etc/rc.d/init.d/mysql restart There [...]
Remote access to mysql database
Step 1 : vi /etc/my.cnf --------------------------------------------- pid-file = /var/run/mysqld/mysqld.pid socket [...]
mysql showing wrong version on cpanel
edit /home/username/.cpanel-datastore/_usr_sbin_mysqld_--version if you have multiple accounts with problem find [...]
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 [...]
Mysql database restore
mysql backup: var/lib/mysql#mysqldump xx > xx.sql mysql restore: var/lib/mysql#mysql xx [...]