mysql

新增用户

CREATE USER 'new_username'@'localhost' IDENTIFIED BY 'new_password';
授权--GRANT ALL PRIVILEGES ON your_database_name.* TO 'new_username'@'localhost';

给予选择权限

GRANT SELECT ON customers.* TO 'sdkj'@'localhost';

给予插入权限

GRANT INSERT ON pyt.* TO 'sdkj'@'localhost';

刷新

FLUSH PRIVILEGES;
查看

SELECT user, host FROM mysql.user;

sudo apt install vim ssh apache2 php mysql-server mysql-client php-mysql libapache2-mod-php  mysqli  cups  gcc  -y

extension = mbstring
extension = mysqli
extension = pdo_mysql

查看使用的引擎

select engine from information_schema.tables where table_schema = 'dish' and table_name = 'all_dish';