After the installation is complete, MySQL uses a blank password by default. You can set a password for the root user. Note the case sensitivity: mysqlSETPASSWORDFORroot @ localhostPASSWORD (admin ); log on to mysql and use the root account $ mysql -- userroot -- passwordrootmysql to authorize the root account to remotely access mysqlgrantallpriv
After the installation is complete, MySQL uses a blank PASSWORD by default. You can SET a password for the root user. Note that the case sensitivity is mysql set password for root @ 'localhost' = PASSWORD ('admin '); // log on to mysql using the root account $ mysql -- user = root -- password = root mysql // authorize the root account to remotely access mysqlgrant all priv
After the installation is complete, MySQL uses a blank password by default. You can set a password for the root user. Note the case sensitivity.
Mysql> set password for root @ 'localhost' = PASSWORD ('admin ');
// Log on to the mysql root Account
$> Mysql -- user = root -- password = root mysql
// Authorize the root account for remote access
Mysql> grant all privileges on *. * to 'root' @ '% 'identified by 'root ';
// Delete the database
Drop database test;
Create a database
Create dababase test;
// Import the SQL File
# Creating a database
Create database jeecms_2012;
Source/home/zhangshibo/jeecms. SQL;