join free version

to see where the error is. Generally more obvious. Can Google.5. When the command enters MySQL, it enters the mariadb. But without MySQL database, launch database, execute mysqladmin-u root-p password Mima, next let input password, direct enter (default password is empty). Then log in Mysql-u root-p, enter the password you set Mima;6. Then show databases; there is a MySQL database. Execute the following command: Update user set Password=password (' Mima ') where user= ' root '; flush privileges

command is: net start MySQLMethod Two:Open the Administration Tools service and locate the MySQL service.Start the service by right-clicking to start or by tapping on the left-hand boot directly. 6. Change the password of the root account The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. Example: 123456C:>mysql–urootMysql>show databases;Mysql>use MySQL;Mysql>update user SET Password=password ("123456

password for the root account is empty when the installation is complete, and you can modify the password to the specified password. Example: 123456C:>mysql–urootMysql>show databases;Mysql>use MySQL;Mysql>update user SET Password=password ("123456") WHERE user= ' root ';Mysql>flush privileges;Mysql>quit7. mysql Console shortcut established:1) object location input, new shortcut, right-click, Desktop: C:\Windows\System32\cmd.exeShortcut name self-defined, OK, shortcut established successfully2)

,--console the output of the command to the console (in order to view the password)The latter will use the default empty string as the password.Vi. start the MySQL serviceCommand line execution net start MySQLClose service net stop MySQLWhere MySQL is the service name of the above customization;Vii. Modifying a custom passwordExecute command mysql-u root-p (if the password is empty, you can also use mysql-u root--skip-password)And then enter the password to successfully connect MySQL;Three ways

two, common error analysis: 2.1 When you start MySQL, you are prompted Starting Mysql.manager ofPid-fileQuit without updating file. If the error message appears, the startup script file is not modified, basedir and DataDir are not specified.Of course, it depends on the log file. 2.2 Initialize MySQL error error:1004 can ' t ' Create file '/tmp/#sql618_1_0. frm ' (errno:13) Change the permissions of/tmp to 777chmod 777/tmp.Third, the error log after specifying DATADIR, the MySQL error log is gen

Tags: using alt AC Max technology to share port inf Char Sha1. Unzip to the location you want to install, create the My.ini file　　The contents of My.ini are as follows　　[mysql]# set MySQL client default character set Default-character-set=utf8[mysqld] #设置3306端口port = 3306# Set the installation directory for MySQL Basedir=d:\program files\mysql-5.7.21-winx64# set the data storage directory for the MySQL database Datadir=d:\program files\mysql-5.7.21-winx64\data# allow the maximum number of connec

you can modify the password to the specified password. Example: 123456C:>mysql–urootMysql>show databases;Mysql>use MySQL;Mysql>update user SET Password=password ("123456") WHERE user= ' root ';Mysql>flush privileges;Mysql>quit7. mysql Console shortcut established:1) object location input, new shortcut, right-click, Desktop: C:\Windows\System32\cmd.exeShortcut name self-defined, OK, shortcut established successfully2) Right-click the shortcut you just created, and then change the target column t

--defaults-file= "D:\Program files\mysql\mysql-5.6.25-winx64 \my.ini " 4 starting the MySQL service method One:The start service command is: net start MySQLMethod Two:Computer Right-manage-services and applications-services to find the MySQL service. start the service by right-clicking to start or by tapping on the left-hand boot directly. 5 Changing the password of the root account The default password for the root account is empty when the installation is complete, and you can modify the