要设置密码的特殊字符，请使用以下语法 -
create user 'yourusername'@'yourhostname' identified by 'yourspecialcharacterpassword';
让我们实现上述语法来创建一个新用户并使用特殊字符设置密码 -
mysql> create user 'mike'@'localhost' identified by 'mike_123456';query ok, 0 rows affected (0.35 sec)
让我们检查存储 mysql 用户和主机的表 -
mysql> select user,host from mysql.user;
这将产生以下输出。新用户创建成功 -
+------------------+-----------+| user | host |+------------------+-----------+| bob | % || charlie | % || robert | % || user2 | % || mysql.infoschema | % || mysql.session | % || mysql.sys | % || root | % || @username@ | localhost || adam smith | localhost || chris | localhost || david | localhost || james | localhost || john | localhost || john doe | localhost || mike | localhost || user1 | localhost || am | localhost || hbstudent | localhost || mysql.infoschema | localhost || mysql.session | localhost |+------------------+-----------+21 rows in set (0.00 sec)
以上就是创建新的 mysql 用户时为密码设置特殊字符？的详细内容。