Articles

 DEFAULT CHARSET=latin1 or collate latin1_general_ci NOT NULL default or TIMESTAMP errors on importing a database dump

Should you get one of the following errors on importing a MySQL database dump you are most likely...

 How can I backup my MySQL Database?

You can use PhpMyAdmin to dump the contexts of a database to a *.sql file. You can also use...

 How can I start and stop mysql?

The standard start/stop scripts are located in /etc/init.d or for older linux versions...

 How do I allow remote MySQL connections?

To allow outside hosts to connect to our MySQL servers do the following: Log into your Cpanel...

 MySQL FLUSH Commands.

Flush privileges mysql> FLUSH PRIVILEGES; when we grant some privileges for a user, running...

 PHPMyAdmin shows every database when logging in as a user

If phpmyadmin shows all the databases on a server when it should only show the users databases do...

Powered by WHMCompleteSolution