0
votes
0answers
9 views

#2002 Cannot log in to the MySQL server / Connection for controluser as defined in your configuration failed

I use PHP/MySQL in Ubuntu 13. To reduce the size of ibdata1, i followed this post What is the best way to reduce the size of ibdata in mysql? and make necessary changes as told in the answer. I did ...
0
votes
2answers
671 views

reset mysql root password on ubuntu

In short: my goal is to reset mysql root password on ubuntu. Background: I set up a ubuntu desktop and installed LAMP stack last week. I then went to do something else, and just got back to carry on ...
3
votes
2answers
500 views

How to forcibly create/modify MySQL user grants, without restarting the database service

I am familiar with how to start MySQL server with the "--init-file" option, or the "--skip-grant-tables" options. However I have a nagios based mysql monitor, which needs to query a table, and ...
2
votes
2answers
3k views

Reset MySQL root password in LAMPP server on Ubuntu

I forgot the password I changed for the root user of MySQL. I'm logged in as root user and when I do # /opt/lampp/lampp security it gives result as XAMPP: Quick security check... XAMPP: Your XAMPP ...