mysql operations via terminal

2019独角兽企业重金招聘Python工程师标准>>>

1.install mysql

apt-get install -y mysql-server python-mysqldb

sed -i 's/127.0.0.1/0.0.0.0/g' /etc/mysql/my.cnf

restart mysql

service mysql restart

2.delete database

To delete a database from a MySQL server instance, we need to make a DROP DATABASE call against the server.

First, fire up MySQL in your terminal and login as an administrator account with:

mysql -u root -p

You will be prompted for your root password before being granted access to the MySQL monitor.

Now to grab a list of available databases on the system. Running:

show databases;

Will result in quite a list of available databases being drawn on the screen (note, it only lists the databases your user account has privileges to see). Once you have located the database you wish to delete in this list we can proceed:

drop database if exists mydatabase;

This will now delete the mydatabase database from the MySQL server if it exists. If not, the drop database statement is simply ignored.

3.delete an user account

To delete a user account from a MySQL server instance, we need to make use of a DROP USER call to the mysql.user table.

First, fire up MySQL in your terminal and login as an administrator account with:

mysql -u root -p

You will be prompted for your root password before being granted access to the MySQL monitor.

Now to grab a list of available user accounts on the system. Running:

select user,host from mysql.user;

Once you have spotted the account you wish to remove, run the following query:

drop user 'username'@'localhost';

转载于:https://my.oschina.net/u/238880/blog/77111