MySql–notes

mysql> create database test7000mysql;

mysql>grant usage on *.* to hasse@localhost identified by 'none';

mysql> grant all privileges on test7000mysql.* to hasse@localhost ;

 

 

Connection string:

Server=localhost;Database=test7000mysql;Uid=hasse;Pwd=none;

 

mysql>use test7000mysql;

mysql>select * from class1;