The MySQL command line tool mysqldump is used to create backup copies (or dumps) of databases including the structure or schema and the data itself. There are a number of command line flags which can get MySQL to dump just… Read more ›
This error comes from a wordpress limit_login plugin. Due to load balancing and DDoS protection the majority of our IPs are behind loadbalancers, as a result limit login plugin always sees the IP of the load balancer as the IP… Read more ›
Global privileges – Privileges are grouped according to the version that supports. Privileges support by all MySQL version
Shutdown MySQL service
|
1 |
# service mysqld stop |
Start MySQL Service in safe mode
|
1 |
# mysqld_safe --skip-grant-tables |
Login as root
|
1 |
#mysql -u root |
update root password
|
1 2 3 4 |
mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD ('New Password') WHERE User='root'; mysql> FLUSH PRIVILEGES; mysql> quit; |
Restart service MYSQL as normally
|
1 2 3 |
# service mysqld restart or #/etc/init.d/mysqld restart |