I forgot the MySQL root password. How do I reset MySQL root password?
{ 16 comments }
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 }
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 }