Skip to main content

Recover Mysql ROOT Password

Stop the MySQL service

# /etc/init.d/mysqld stop

Add skip-grant-tables

# edit /etc/my.cnf and add skip-grant-tables under [mysqld] section

Start the MySQL service

# /etc/init.d/mysqld start

Log into the MySQL server without any password

# mysql

Reset the password for ‘root’ user

mysql> use mysql
mysql> UPDATE user SET password=PASSWORD('password.new') where user='root';

Flush privileges

mysql> flush privileges;

Stop the MySQL service

# /etc/init.d/mysqld stop

Edit my.cnf and remove skip-grant-tables

Start the MySQL service

# /etc/init.d/mysqld start

Log-in with the new password
# mysql -u root -p password.new

Comments

x0nm6480fy said…
When comparable bets from throughout quantity of} sportsbooks are lined up, the traces from FanDuel will typically give marginally higher returns. Maryland is fortunate to have two NFL teams play their house video games within the state, with each the Baltimore Ravens and Washington Commanders competing within the Old Line State. However, currently, the only way to guess on the two teams’ fortunes is to go to one of many 4 retail sportsbooks which are currently operational within the state. However, these regulator run self-exclusion schemes only prolong as far as gambling sites that are be} licensed in that nation. With lots of, if not 1000's, of rogue gambling operators accepting 1xbet korean players utilizing a|with no} license gained't} be lined by the nationwide self-exclusion schemes, there are cracks within the safety being supplied. In 2019, after seeing fast development in demand for the BetBlocker device, it was concluded that it was not financially sustainable to continue to run BetBlocker as an add on to the ADR service.
January 1, 2023 at 1:26 PM
Post a Comment

Popular posts from this blog

DKIM PROXY FOR OUTGOING MAIL IN POSTFIX

1.  Download DKIM proxy         wget http://downloads.sourceforge.net/dkimproxy/dkimproxy-1.3.tar.gz         perl -MCPAN -e'CPAN::Shell->install("Net::Server")'         perl -MCPAN -e'CPAN::Shell->install("Mail::DKIM")'         perl -MCPAN -e'CPAN::Shell->install("Mail::DKIM")'                tar -zxvf dkimproxy-1.3.tar.gz         ./configure --prefix=/usr/local/dkimproxy         make install         2. Generate Public and Private Key         Generate a private/public key pair using OpenSSL:                 openssl genrsa -out private.key 1024             opens...
Post a Comment
Read more