I forgot the MySQL root password. How do I reset MySQL root password?
{ 16 comments }
MySQL DBA Tutorials & HowTos
MySQL tutorials and howtos for database admins, sysadmins, DBAs, webmasters, and Unix/Linux users who wish to improve their database skills such as backup, security, optimization, management and much more (rss feed).
Can you tell me the location of for the MySQL error log file under Debian or Ubuntu Linux? How do I view error log file?
{ 2 comments }
I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?
{ 2 comments }
Where are my mysql database and table files are stored in UNIX or Linux operating systems?
{ 0 comments }
How do I delete a column from an existing MySQL table using UNIX / Windows / Linux mysql command line utility sql syntax?
{ 4 comments }
Q. How do I find out which table is consuming resources under MySQL Database server from UNIX shell prompt?
{ 3 comments }
Q. I get a large amount of bin files in the MySQL data directory called “server-bin.n” or mysql-bin.00000n, where n is a number that increments. What is MySQL Binary Log? How do I stop these files being created?
{ 10 comments }
