Monthly Archives: January 2012

//January
­
20 01, 2012

Enabling Multibyte.

By |January 20th, 2012|server issues|0 Comments

For enabling Multibyte support , we need to recompile php on the server with mbstring

20 01, 2012

Mysql Database Dumb n Restore

By |January 20th, 2012|Mysql|0 Comments

Creation of database In Mysql Prompt > create database <databasename>;  Drop Dtabase> Im mysql prompt > Drop database <database name>; Dump ALL MySQL Databases: mysqldump –user=XXXXXXXX –password=XXXXXXX -A > /PATH/TO/DUMPFILE.SQL Dump Individual or Multiple MySQL Databases: mysqldump –user=XXXXXXXX –password=XXXXXXX –databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL Database dump and restore mysqldump -u admin -p`cat /etc/psa/.psa.shadow` <database [...]

20 01, 2012

Mysql Password

By |January 20th, 2012|Mysql|0 Comments

In cpanel Login WHM ---> mysql root password --> Given the new password. cat /root/.my.cnf will list the password for mysql In Kloxo Search ---> passwordMysql ---> reset the password, For manually changing service mysqld stop mysqld_safe --skip-grant-tables & then exit from the mysql by typing quit then type #mysql -u root mysql (Since you’ve [...]

20 01, 2012

Mysql login ‘n’ privilages

By |January 20th, 2012|linux, Mysql|0 Comments

login to mysql as admin user mysql -u admin -p`cat /etc/psa/.psa.shadow` login to mysql as a user with a database mysql -u <user> -p<password> <database>  login to mysql as remotely mysql -u <user> -p<password> <database> -h <ipaddress> Grand Privilage to a user grant all privileges on dbsbcstudio.* to 'user name'@'localhost' identified by 'password'; flush previlages [...]

20 01, 2012

Mysql -Important Locations

By |January 20th, 2012|linux, Mysql|0 Comments

/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 are other places MySQL looks for configuration files /etc/my.cnf /etc/mysql/my.cnf ~/my.cnf <$MYSQLHOME>/my.cnf ~/.my.cnf

Load More Posts