mysql

mysql -hlx13.hoststar.hosting -u ch45859_solar -p..... ch45859_solar #db

• mysql https://dev.mysql.com/doc/refman/8.0/en/
  • create database xyz;
  • select user, host from mysql.user;
  • create user u identified by 'pw';
  • create user u@'localhost' identified by 'pw'; // beide creates sind nötig!
  • grant all on xyz.* to 'u';
  • grant process on *.* to 'u'; -- nötig für dump table (ist global also auf *.*! - aber nützt nicht, mysqldump braucht stattdessen option --no-tablespaces )
  • show grants for u;
• SHOW VARIABLES LIKE "%version%";
• sql to drop tables
  • tee spNxtDrop.sql;
  • select concat('drop table ' , table_name , ';') from information_schema.tables where table_schema = 'spNxt';
  • notee;