解åMySQLå缩å
å°ä»¥ä¸è½½çMySQLå缩å
解åå°èªå®ä¹ç®å½ä¸ã
3. æ·»å ç¯å¢åé
åéåï¼MYSQL_HOME
åéå¼ï¼D:\Program Files\mysql-5.6.22-winx64
å³ä¸ºmysqlçèªå®ä¹è§£åç®å½ã
åå¨Pathä¸æ·»å %MYSQL_HOME%\bin
4. 注åwindowsç³»ç»æå¡
å°mysql注å为windowsç³»ç»æå¡
æä½å¦ä¸ï¼
1ï¼æ°å»ºä¸ä¸ªmy.iniæ件并æmy.iniæ件æ·è´å°c:\windowsç®å½ä¸ï¼my.iniå
容å¦ä¸ï¼
[client]
port=3306
default-character-set=utf8
[mysqld]
# 设置为MYSQLçå®è£
ç®å½
basedir=D:\Program Files\mysql-5.6.22-winx64
# 设置为MYSQLçæ°æ®ç®å½
datadir=D:\Program Files\mysql-5.6.22-winx64/data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
2ï¼ä»æ§å¶å°è¿å
¥å°MySQL解åç®å½ä¸ç bin ç®å½ä¸ã
3ï¼è¾å
¥æå¡å®è£
å½ä»¤ï¼
mysqld.exe -install
å¦æåºç°Install/Remove of the Service Denied!
æ¯å 为WINDOW 7 è· vista çæéæ´ä¸¥æ ¼
è¿å
¥ C:\Window\System32 æ¾å°CMD.EXE å³é®éæ© ä»¥ç®¡çå身份 è¿è¡ï¼åè¿å
¥ç¸åºç®å½æ§è¡å½ä»¤ï¼ä¸åå°±OKäºã
å®è£
æååä¼æ示æå¡å®è£
æåã
注ï¼my-default.iniæ件å¨MySQL解ååçæ ¹ç®å½ä¸ï¼å¦æ没æï¼å¯ä»å
¶ä»å°æ¹ä¸è·åã
移é¤æå¡å½ä»¤ä¸ºï¼mysqld remove
5. å¯å¨MySQLæå¡
æ¹æ³ä¸ï¼
å¯å¨æå¡å½ä»¤ä¸ºï¼net start mysql
æ¹æ³äºï¼
æå¼ç®¡çå·¥å
· æå¡ï¼æ¾å°MySQLæå¡ã
éè¿å³é®éæ©å¯å¨æè
ç´æ¥ç¹å»å·¦è¾¹çå¯å¨æ¥å¯å¨æå¡ã
6. ä¿®æ¹ root è´¦å·çå¯ç
åå®è£
å®ææ¶rootè´¦å·é»è®¤å¯ç 为空ï¼æ¤æ¶å¯ä»¥å°å¯ç ä¿®æ¹ä¸ºæå®çå¯ç ãå¦ï¼123456
æ¹æ³ä¸ï¼
c:>mysql âuroot
mysql>show databases;
mysql>use mysql;
mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES; ã注æä¸å®ä¸è¦éå¿è¿å¥è¯ï¼å¦åå¯ç æ´æ¹ä¸è½çæã
mysql>QUIT
温馨提示:答案为网友推荐,仅供参考