<!DOCTYPE html> <html> <head> </head> <body> <div> <pre style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;">service mysql stop mysqld_safe –skip-grant-tables & mysql -u root USE mysql UPDATE user SET Password = PASSWORD('password1234') WHERE Host = '%' AND User = 'root'; </pre> <pre style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;">FLUSH PRIVILEGES; service mysql start Then log in with root like this: mysql -p and write the password </pre> <pre style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium;">DB list via SQL: show databases; Delete a database via SQL: drop <nome_db>; Create database via SQL: create database <nome_db>; </pre> </div> </body> </html>
Subscribe
0 Comments
Oldest