MySQL Installation issues

1. mysql-5.5.60-winx64 Zip Installation

Create a My.ini file and fill in the contents as follows

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=c:\program Files (x86) \mysql-5.5.60-winx64
# Set up a storage directory for MySQL database data
Datadir=c:\program Files (x86) \mysql-5.5.60-winx64\data
# Maximum number of connections allowed
max_connections=200
# The character set used by the service side defaults to the 8-bit encoded latin1 character set
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb

Setting environment variables (WIN10)

C:\Program Files (x86) \mysql-5.5.60-winx64\bin

C:\Program Files (x86) \mysql-5.5.60-winx64

%mysql_home%\bin

3. Installing the MySQL Service

Administrator mode

mysqld-remove//installation error can uninstall the service and install mysqld--initializenet start mysql//start mysqlnet stop mysql//stops MySQL mysql-u root

　　

On this, the mysql-5.5.60-winx64 installation was successful.

2.mysql-8.0.11-winx64.zip Installation

Similar to the above steps, but login MySQL show denied access

Workaround:

You can find the file that ends with. Err in the extracted file , choose to open it in Notepad, and then search within the file for password

Mysql-u Root-p Enter the red box password to find the password.

MySQL Installation issues