Copy Code code as follows:
Error code 1045
Access denied for user ' root ' @ ' localhost ' (using Password:yes)
The workaround is to reset the root password by following the steps in the Windows platform:1, as a system administrator
Found a solution from the Internet, here to record:
1. Admin login system, stop MySQL service or end mysqld-nt process;2. Go to the command line and come to MySQL's installation directory. Suppose the installation directory is d:/mysql/, cmd enter
Based on the previous article method, the batch command is added to automate the backup process. Just because the name of the backup file in the batch command is unique in terms of time, make a special arrangement.
1. Copy Date folder Backup
======
Iis|mysql|window
First, software preparation: The following are the latest official version as of 2005-4-20PHP (5.1.2): http://www.php.net
MySQL (5.0.19): http://www.mysql.com
Zend Optimizer (2.6.2): http://www.zend.com
phpMyAdmin (2.8.0.2):
apache|mysql| Tips | Original I used the version is very new ...
Apache for Apache_1.3.26-win32-x86-no_src.exe (down in the official)
PHP for php4.23 (www.pconline.com inside)
MySQL is 3.23 inside the pconline.com. Only APACHE.EXE (Pconline zip to
Mysql
4.1 is a beta version of Alpha, this version is not made for dummies or many inconvenient installation programs. However, I quite like it myself.
The distribution of the compression package situation:) Here's my new installation and upgrade to
one, MySQL installation1, the official website Download Community Edition2. Unzip to C Drive: C:\mysql-5.7.21-winx643. Run command line as Administrator , enter directory C:\mysql-5.7.21-winx64\bin4. Registration
1 Installation and Operating environment VC + + 20132 Downloads Https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-winx64.zip3 Decompression4 environment variables, advanced system settings, properties---My computer. Click Path in the system
1. Zip:Https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-winx64.zip2. Official Document Location:Http://dev.mysql.com/doc/refman/5.7/en/installing.html3. Extract the files to your favorite location, I extracted to the C: Packing directory4.
MYSQL 5.6 is different from the previous version of the features, the first installation of the root of the default password is not empty, but randomly generated, the specific process is as follows1. Download the version.We chose to download this
Windows:1. Log into the system with the system administrator.2. Stop the MySQL service.3. Go to the Command Window (CMD) and enter the MySQL installation directory, for example, my installation directory is c:\mysql, enter C:\mysql\bin4. Skip
Error code 1045Access denied for user ' root ' @ ' localhost ' (using Password:yes)The workaround is to reset the root user password by following the steps in the Windows platform:1. Log in to the system as a system administrator;2. If the MySQL
1. Environment preparation1.1 Win7 x64 system1.2 Postgresql-9.1.13-windows-binaries.zip and Mysql-5.5.46-win32.zip2. Installation process2.1 Postgresql-9.1.13 installation process① extract the Zip-format installation package to a folder, such as
1, download MySQL-5.6 from the official MySQL website mysql.com find MySQL Community Server 5.6 for the http://dev.mysql.com/downloads/mysql/, here you can choose the operating system platform. There are three optional download files under the
MySQL is a relational database management system, the official website is http://www.mysql.com/, divided into MySQL Enterprise Edition (commercial), MySQL Cluster CGE, MySQL Community Edition Three versions, the first MySQL Enterprise edition need
Install, uninstall MySQL service
Install MySQL Service
Create and edit a bat file with the following contents (E:\mysql\bin\mysqld-nt.exe for installation directory, fill in the actual situation)
@ECHO off
E:\mysql\bin\mysqld-nt.exe-install
net
ErrorCode1045Access denied for user ' root ' @ ' localhost ' (using Password:yes) The workaround is to reset the root user password in the Windows platform under the following steps: 1, log on to the system as a system administrator, 2, if the MySQL
1-Download the free install version from www.mysql.com website, zip suffix2-After decompression, modify the folder name MySQL "Optimize under name, easy to remember", and cut to C root directory3-Create the empty folder data under the root of the
1After installing MYSQL, change the ROOT password and useNet startmysqlI encountered this problem at startup.C: \ mysql \ bin \ mysqladmin-u root-p shutdownNet start mysql does not have this error prompt!*************2MySQL error 1067Q: I
Mysql-5.7.12-winx64 Configuration documentation Hou Zhiyu due to document pictures are not convenient to upload, so the reference in the document pictures are not uploaded up, if you need to go to my documents to download this document; recently I
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.