 | How to reset a mySQL password? |  |
 | If you have lost your root user password for MySQL, you can reset it with the following procedure:
Take down the mysqld server by sending a kill (not kill -9) to the mysqld server. The pid is stored in a |
|
|
| Repairing MySQL tables that will not open |  |
| This should be handled on a case by case basis, but if you are using the default MySQL table type of MyISAM (which is the default storage engine unless changed or specified differently) here are a few options:
|
|
|
| Securing MySQL | |
| Due to differing needs and requirements this is difficult to answer except on a case by case basis. The MySQL website has a section regarding general security of a MySQL database available here: |
|
|
| What is my root password for MySQL? | |
|
If the server was auto provisioned with MySQL then the root password is the same as the server root password.
If you hav |
|
|
| What is the best online resource for information about MySQL? | |
| The MySQL website has a complete reference manual with search capabilities available on their website:http://dev.mysql.com/doc/. The manual c |
|
|
| Mysql Basic Commands | |
| [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create database [databasename]; List all databases on the sql server. show databases; Switch to a database. use [ |
|
|
| How to install Mysql | |
| How to install Mysql Via RPM : Please check the following link and get RPM http://httpupdate.cpanel.net/mysqlinstall/ in above list (not rpm) click on the version for which you want to install mysql th |
|
|
| MySQL Optimization / Repair Information | |
| How MySQL Uses MemoryThis page lists some of the ways that the mysqld server uses memory, and associated mysqld variable names |
|
|
| How can I monitor what my MySQL server is doing? | |
| A handy little Linux application called mytop fits this just perfectly. This is a near-time monitor just like the UNIX utility 'top' that specifically looks at what the MySQL server is doing. It updates every few seconds so you can get a reasonable loo |
|
|
| How do I backup MySQL in Linux? | |
| 1. Copying from the mysql directoryBy default, MySQL databases on servers that use Linux are stored in the following directory:/var/lib/mysql/If you shut down the mysqld service first, you can copy your databases to an example /b |
|
|
