mysql 控制台中密码 设置编码方式 判断数据库是否存在

//判断数据库是否存在

// 创建连接
$conn = new mysqli('localhost','root','root');
// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
$sql="SELECT * FROM information_schema.SCHEMATA where SCHEMA_NAME='db_testaaaaa'";
$a =$conn->query($sql);
$b=$a->fetch_assoc();
echo $b["SCHEMA_NAME"];
//var_dump($b);

//mysql 控制台密码

use mysql
Database changed
update user set password=PASSWORD('设置的密码') where user='root';
flush privileges;


//mysql 设置编码
set character_set_client = utf8;


set character_set_server = utf8;


set character_set_connection = utf8;


set character_set_database = utf8;


set character_set_results = utf8;


set collation_connection = utf8_general_ci;


set collation_database = utf8_general_ci;


set collation_server = utf8_general_ci;


//mysql查看编码设置
show variables like "%character%";