Home » Archive by category Msyql (Page 2)

Recover MySQL root password

If you forgot your root mysql password this tutorial with help you to recover the root user passord Stop the MySQL server process. #service myql stop Start again with no grant tables. #mysqld_safe –skip-grant-tables & Login to MySQL as root. Set new password. # mysql -u root mysql>...
Continue reading

Check Optimize, Analyze and Repair tables in database.

If you are experiencing in error/warning in particular mysql table in a database or specific table is corrupted the perform the below command to check and repair the table. #mysqlcheck -c databasename tablename -u root -p To check all tables in database. #mysqlcheck -c databasename -u root -p...
Continue reading

Mysql Command Line.

Mysql Command Line. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. mysql> create database [databasename]; List all databases on the sql server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the db....
Continue reading

Categorized Tag Cloud