MYSQL重新初始化用户帐号(比如root忘了)
来源:互联网 发布:阿里云服务器环境搭建 编辑:程序博客网 时间:2024/04/30 14:14
mysql -u root -p
就可以进入了
然后可以更改密码
use mysql;
update user set password=password('msn') where user='root';
flush privileges;
另外mysql安装好之后,user表里会有多个用户,可以自己整理一下,不要的就删除 3月22日 MYSQL重新初始化用户帐号(比如root忘了)
run the script:
mysql_install_db --user=root
In the installation dir
this should change ownership and make mysql recognise the data dir.
good luck
Ade
Foo Ji-Haw wrote:
> Hi all,
>
> My Windows-based database server crashed (no fault of MySQL. probably
> OS or hardware), and I managed to copy out the data files. I am using
> version 5.0 of the Essentials package.
>
> I tried to install a similar setup on another server, then copy the
> data/ folder over. The MySQL service starts, but I am not able to
> login, even as root.
>
> Is there anyone who can advise me on the recovery steps?
>
> Appreciate your feedback!
>
A.4.1.?How to Reset the Root Password
If you have never set a root
password for MySQL, the server does not require a password at all for connecting as root
. However, it is recommended to set a password for each account. See Section?5.7.1, “General Security Guidelines”.
If you set a root
password previously, but have forgotten what it was, you can set a new password. The following procedure is for Windows systems. The procedure for Unix systems is given later in this section.
The procedure under Windows:
-
Log on to your system as Administrator.
-
Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager:
Start Menu -> Control Panel -> Administrative Tools -> Services
Then find the MySQL service in the list, and stop it.
If your server is not running as a service, you may need to use the Task Manager to force it to stop.
-
Create a text file and place the following command within it on a single line:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
Save the file with any name. For this example the file will be
C:/mysql-init.txt
. -
Open a console window to get to the DOS command prompt:
Start Menu -> Run -> cmd
-
We are assuming that you installed MySQL to
C:/mysql
. If you installed MySQL to another location, adjust the following commands accordingly.At the DOS command prompt, execute this command:
C:/>
C:/mysql/bin/mysqld-nt --init-file=C:/mysql-init.txt
The contents of the file named by the
--init-file
option are executed at server startup, changing theroot
password. After the server has started successfully, you should deleteC:/mysql-init.txt
.If you install MySQL using the MySQL Installation Wizard, you may need to specify a
--defaults-file
option:C:/>
"C:/Program Files/MySQL/MySQL Server 5.0/bin/mysqld-nt.exe"
--defaults-file="C:/Program Files/MySQL/MySQL Server 5.0/my.ini"
--init-file=C:/mysql-init.txt
The appropriate
--defaults-file
setting can be found using the Services Manager:Start Menu -> Control Panel -> Administrative Tools -> Services
Find the MySQL service in the list, right-click on it, and choose the
Properties
option. ThePath to executable
field contains the--defaults-file
setting. -
Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use.
-
You should be able to connect using the new password.
In a Unix environment, the procedure for resetting the root
password is as follows:
-
Log on to your system as either the Unix
root
user or as the same user that the mysqld server runs as. -
Locate the
.pid
file that contains the server's process ID. The exact location and name of this file depend on your distribution, hostname, and configuration. Common locations are/var/lib/mysql/
,/var/run/mysqld/
, and/usr/local/mysql/data/
. Generally, the filename has the extension of.pid
and begins with eithermysqld
or your system's hostname.You can stop the MySQL server by sending a normal
kill
(notkill -9
) to the mysqld process, using the pathname of the.pid
file in the following command:shell>
kill `cat /mysql-data-directory/host_name.pid`
Note the use of backticks rather than forward quotes with the
cat
command; these cause the output ofcat
to be substituted into thekill
command. -
Create a text file and place the following command within it on a single line:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
Save the file with any name. For this example the file will be
~/mysql-init
. -
Restart the MySQL server with the special
--init-file=~/mysql-init
option:shell>
mysqld_safe --init-file=~/mysql-init &
The contents of the init-file are executed at server startup, changing the root password. After the server has started successfully you should delete
~/mysql-init
. -
You should be able to connect using the new password.
Alternatively, on any platform, you can set the new password using the mysql client(but this approach is less secure):
-
Stop mysqld and restart it with the
--skip-grant-tables --user=root
options (Windows users omit the--user=root
portion). -
Connect to the mysqld server with this command:
shell>
mysql -u root
-
Issue the following statements in the mysql client:
mysql>
UPDATE mysql.user SET Password=PASSWORD('
->newpwd
')WHERE User='root';
mysql>FLUSH PRIVILEGES;
Replace “
newpwd
” with the actualroot
password that you want to use. -
You should be able to connect using the new password.
- MYSQL重新初始化用户帐号(比如root忘了)
- mysql创建用户 初始化root密码
- CSDN帐号重新注册了
- mysql root 用户无法远程登陆问题---客户端workbench用root帐号无法登录
- mysql之 root用户忘记了密码
- MYSQL用户帐号管理
- MYSQL用户帐号管理
- mysql重新初始化
- 重新注册用户了
- 安装好MySQL后,用SQL去修改root帐号的密码,结果不能登录了!
- 安装好MySQL后,用SQL去修改root帐号的密码,结果不能登录了!
- 安装好MySQL后,用SQL去修改root帐号的密码,结果不能登录了!
- 安装好MySQL后,用SQL去修改root帐号的密码,结果不能登录了!
- MYSQL忘了ROOT密码
- mysql root密码忘了
- Mysql初始化root密码
- 忘了Oracle的sys用户和MySQL的root用户密码,解决方法
- mysql重新忘记root密码
- 3D游戏从入门到精通-16
- Cisco Switching Black Book
- 怎样才能娶到比尔-盖茨的女儿
- 3 Books in One! - English through pictures - I.A. Richards, Christine M. Gibson
- makefile del:not found 问题
- MYSQL重新初始化用户帐号(比如root忘了)
- 递归 | 树
- [译] Windows rootkits 101
- 开博贴!
- 手机电池何时开始充电为最佳
- 多多积累,程序世界,多彩人生!
- Eclipse3.1.2配置:包括汉化、Lomboz3.1.2配置、Tomcat5.5.17配置!
- 江湖再见--又见sinox... ...
- 扩展DataGrid控件,能够实现多列排序,自定义标题,动态增加表头等