December 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  

Categories

December 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  

MySQL change the default blank password to open Remote Access

mysql -u root -p

use mysql

update user set password=PASSWORD(‘abcde’) where user = ‘root’;

mysql
update user set password=PASSWORD(‘123456′) where user=’root’

mysqld -install

 

 

mysql> show variables like ‘char%’;
mysql>set character_set_client=gbk;
mysql>set character_set_results=gbk;

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>