Show all databases: show databases;. Access database: mysql -u [username] -p [database] (will prompt for password). Create new database: create database ... ... <看更多>

Try this function - SELECT VERSION(); -> '5.7.22-standard'. VERSION(). Or for more details use : SHOW VARIABLES LIKE "%version%"; ... ... <看更多>

It does not list database-specific, table-sepcific, column-specific, routine-specific privileges. There fore, the grant GRANT SELECT ON mydb.* TO myuser@ ... ... <看更多>