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
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 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
