![]() |
طريقة إستعادة الروت Root MySQL Password
Stop the MySQL service (Ubuntu and Debian) Run the following command: Bash: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: Bash: sudo /etc/init.d/mysqld stop Start MySQL without a password Run the following command. The ampersand (&) at the end of the command is required. Bash: sudo mysqld_safe --skip-grant-tables & Connect to MySQL Run the following command: Bash: mysql -uroot Set a new MySQL root password Run the following command: Bash: use mysql; update user set authentication_string=PASSWORD("mynewpassword") where User='root'; flush privileges; quit Note: Change mynewpassword with your own password Stop and start the MySQL service (Ubuntu and Debian) Run the following commands: Bash: sudo /etc/init.d/mysql stop ... sudo /etc/init.d/mysql start (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands: Bash: sudo /etc/init.d/mysqld stop ... sudo /etc/init.d/mysqld start Log in to the database Test the new password by logging in to the database. Bash: mysql -u root -p Enter your new password when prompted. |
رد: طريقة إستعادة الروت Root MySQL Password
شكرا أخي العزيز
|
الساعة الآن 03:40 AM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd
جميع الحقوق محفوظة لمنتديات فنان سات
www.fanansatiraq.com