MySQL5.1 server installation error (MySQL Error 1045)

2011-01-06  来源:本站原创  分类:Database  人气:112 

MySQL installation problems are summarized below in order to later re-installation may be a reference to similar problems.

Installation into the installation steps in the last two error dialog box will pop up the following:

MySQL5.1 server installation error (MySQL Error 1045)

Figure 1

The above error occurs because the password is wrong, if the password is entered correctly the problem does not occur, and if this step below enter the correct password, you can install correctly.

MySQL5.1 server installation error (MySQL Error 1045)

Figure 2

But when I installed the password is obviously a 123, but now when the input 123 is not installed, how is it?

To solve the problem we must enter the correct password, but how if you do not know the password or the password is not correct, then how to do it?

Then remove the registry, reinstall, but no.

(Reinstall - uninstall - clean up the registry) after the implementation of several not install correctly, so only checked on the net.

About Installing MySQL Server Instance Config Wizard error when, on-line, many say, are as follows:

The first argument:

Because before you had installed mysql, uninstall Shihai retains some configuration files.
Click Retry (retry) to see if you can. Otherwise, click Skip (skip) and then click cancel to exit, and then click on the Start menu MySQL Server Instance Config Wizard to reconfigure mysql.

In Figure 2, there are three places to enter a password, that you have installed mysql, you are in the first text box to enter the original root password, followed by two text box to enter root's new password on it.

If this does not then reload a MySQL.
Heavy Note: All the best to delete the original files, if necessary, can be clear about the registry.

"The original root password?" I entered, but no.

Then I clean up the registry uninstall, reinstall MySQL, but does not work. Why? I then check the Internet.

The second argument:

"Step one: Open the" Start "to run the program in the MYSQL MySQL Command Line Client to enter your password [that is set during installation]
Step Two: mysql> enter: UPDATE mysql.user SET Password = OLD_PASSWORD ('password')
The third step: at the prompt -> enter: WHERE Host = 'localhost' AND User = 'user name';
Enter after the prompt: Query OK, 0 rows affected (0.16 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Do not think that over, there are ~
The fourth step: mysql> enter: FLUSH PRIVILEGES
Enter after the prompt: Query OK, 0 rows affected (0.19 sec)
A2:
Start the mysql service, log on to mysql database
Enter the command is:
[Root @ localhost root] # / usr / bin / mysql-u root-p *
(Based on lniux version compatibility issues,-p input after the contents will vary)
-P: root password for the database administrator (typically enter the password)
-P: Specifies the database name to be used then, Enter password: Enter the database password here (redhat 9.0 version)
In the redhat 9.0 version, if the root directly into the database administrator's password, an error will occur 1045.
Methods provided for the A1, in the sense of trouble with the process, so stop the validation.
In fact, or a word, version compatibility issues. 9.0 use and service mysqld start myisamchk can know.
These are two days to play little bit of problems encountered in MySQL

"

99% online this argument, really do not understand, 163 blog, javaeye, csdn, there are many other technical websites are the articles, with no innovation, just copy to their own blog or website, not to be a real operating instructions, boring.

The above question is: when I installed the password is 123 fill, but can not enter into, the problem of how to enter without a password MySQL Command Line Client, as shown in Figure:

MySQL5.1 server installation error (MySQL Error 1045)

Figure 3

See, first of all is to enter a password, how can this way, no password and can not enter the MySQL client console, so the second method does not work.

These two do not solve my problem, saw nothing but their own, and I remember saying: "There is always a successful way," I think I have to fix it.

Some say that the initial password is 123456, how possible. I tested one by one, finally, I do not enter any password, enter directly in the Figure 2 New root Password and Comfirm, completed the implementation of the correct result.

If the installation several times unsuccessful, it could be passwords, your password is test previously used several times, and if not, would not enter the Current root Password password, the password directly into the following two items can be.

相关文章
  • MySQL5.1 server installation error (MySQL Error 1045) 2011-01-06

    MySQL installation problems are summarized below in order to later re-installation may be a reference to similar problems. Installation into the installation steps in the last two error dialog box will pop up the following: Figure 1 The above error o

  • NO.1130 ERROR MYSQL error solution 2010-10-20

    If you want to connect to your mysql when this error occurs: ERROR 1130: Host '10 .10.27.44 'is not allowed to connect to this MySQL server Solution: 1. Change the table method. Your account may be allowed from a remote landing, only localhost. This

  • Create a table using mysql error: Mysql error 150 2010-04-26

    can't creat table '\ oadb \ user_menu.frm' (errno: 150) three possible reasons: 1. Foreign key and is not the same type of foreign key references, such as integer and double 2. Can not find column to be referenced 3. Not the same character encoding t

  • mysql set max_allowed_packet to solve MySQL Error Nr.2006-MySQL server has gone away problem 2010-04-03

    When using the mysql database restore time to do, because some of the data much, so need to set the max_allowed_packet parameter to control the maximum length of its communication buffer. Otherwise, this error occurs: The MySQL Server returned this E

  • mysql error: Client does not support authentication protocol requested by server 2011-02-17

    Programming today, there is a following error: mysql error: Client does not support authentication protocol requested by server, consider upgrading MySQL The client's authentication protocol is inconsistent with the server, you need to update the cli

  • MYSQL Error 2006: MySQL server has gone away solution 2011-07-08

    mysql version mysql_5.1.50 Purpose: To make a database export and import Export without problems, but relatively large database, sql file with 900 + M Re-imported when the error MYSQL Error 2006: MySQL server has gone away ----------------------- The

  • spider storage engine encountered in practice [Mysql:: Error: This xid is already exist: COMMIT] solution 2010-07-07

    References Bowen: http://ilgnep.javaeye.com/blog/706109 In the project application spider storage engine, we found the following when uploading files database error: [Mysql:: Error: This xid is already exist: COMMIT] Solution: In the spider main conf

  • Installation MySQL5.1 server errors (MySQL Error 1045) 2011-01-06

    MySQL installation problems encountered are summarized below in order to later re-installation may be a reference to similar problems. Installation, installation steps into the last two error dialog box will pop up the following: Figure 1 The above e

  • MYSQL installation there could not start the service mysql error: 0 treatment 2010-03-07

    When you install, reinstall when you could not start the service mysql error: 0 error, you can try the following two ways. 1, Mode 1 MySQL installation is there could not start the service mysql error: 0 prompt error solution: First, in the Administr

  • MySQL installation is there could not start the service mysql error: 0 2010-04-16

    mysql-5.0.18-win32 encountered a problem, such as the title. Today, costs a great deal of enthusiasm, still not resolved, I remember I used to be very easy to install on the, how now ..... Depressed died, I found a lot of online methods, one by one n

  • Installation. Reinstall when could not start the service mysql error: 0 error or start service stops moving when 2010-04-02

    On the XP install mysql-5.1.45-win32.msi questions to me the whole five hours, finally done! When installed, sometimes there could not start the service mysql error: 0 prompt error. Solving steps: 1, start-MySQL-MySQL Server 5.1-MySQL Server Instance

  • Solution Mysql ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' 2010-07-02

    Mysql ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' solution to the problem Such issues need to force re-edit the password, as follows: / Etc / init.d / mysql stop (service mysqld stop) / Usr / bin / mysqld_safe - skip-grant-tables

  • 解决Mysql ERROR 1045 (28000): Access denied for user 2014-10-23

    在ubuntu server 12.04中,安装mysql后,使用命令登录mysql居然报错了,Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost'(using password: YSE),这个错误搞得很郁闷,仔细分析之后,知道这个报错和密码有关,可能是密码在配置mysql的时候异常,所以导致我们没有正确的密码,知道问题后,立即想到解决办法了,那就是重新设置一个密码,方法如下 1.先关闭mysql并设置密码 #s

  • MYSQL ERROR 1045 error solution 2010-02-23

    MYSQL ERROR 1045 error about a solution 1, mysql-u root 2, use mysql 3, update user set password = old_password ('scf') where user = 'root' and host = 'localhost'; 4, FLUSH PRIVILEGES;

  • [Change] mysql error (ERROR 1045 (28000): Access denied for use) of the solution 2010-07-05

    Transfer] [mysql error (ERROR 1045 (28000): Access denied for use) of the solution ERROR 1045 (28000): Access denied for user 'xcj' @ 'localhost' (using password: YES) mysql this error can be resolved: 1. To root user login 2. Use mysql; 3. Select c.

  • Installation REDMINE, there Mysql:: Error: BLOB / TEXT column 'description' 2010-08-21

    When installed, there will be Mysql:: Error: BLOB / TEXT column 'description' can't have a default value: ALTER TABLE `projects` CHANGE `description` `description` text DEFAULT'' This problem can be resolved as follows: I think your problem in issues

  • SQL Server installation error pending file operations solution 2010-09-02

    SQL Server installation file operations pending the wrong solution to install SQL Server 2000 Error: "In the past a program installation created pending the installation files on the computer operation. Before running Setup must restart your computer

  • Mysql error 0 & 1045 2011-05-30

    Today, the company installed Mysql, even installed, the report Mysql error 0 errors, checked on the net, and said there is no uninstall previously installed clean, but I first installed it, but, well, I uninstall and reinstall the again, still the sa

  • mysql error from the server solution: Slave_SQL_Running: No (master - slave) 2011-10-19

    mysql server-based - from configuration, and found not from the MySQL Slave and host synchronization, see Slave status: mysql> show slave statusG Slave_IO_Running: Yes Slave_SQL_Running: No Last_Errno: 1062 .... Seconds_Behind_Master: NULL Reasons: 1

  • MYSQL ERROR 1045 (28000): Access denied for user (using password: YES)问题的解决 2015-03-12

    Mysql中添加用户之后可能出现登录时提示ERROR 1045 (28000): Access denied for user的错误. 第一种方法: 推荐 错误描述: Mysql中添加用户之后可能出现登录时提示ERROR 1045 (28000): Access denied for user的错误. 原因分析: 在mysql.user表中可能出现user为空的记录,如: mysql> select host,user from user; +------------------+------+