MySQL MySQL Workbench use

Source: Internet
Author: User
Tags mysql create

The use of MySQL Workbench

There are multiple visual tools for MySQL, where we use MySQL workbench to create databases and tables. "Visualization tools can improve productivity". We need to use the most convenient method to deal with problems in our work, which reduces our workload and improves work efficiency, so the author does not advocate the use of black Command box in the process of working.

1. Download:

2. Installation:

3. Use:

MySQL Create, delete users, query all users and other tutorials, improve your MySQL security
2013-10-14 11:16:10 I'd like to say two keyboard start pages
favorites I want to contribute
MySQL Create, delete users, query all users and other tutorials, improve your MySQL security   recommended that you do not use the root account of MySQL to connect your Web pages to the database, which may cause users to obtain your database account password through the Web, there are serious security risks. It is recommended to create a new account, the permissions are basically sufficient, and then use the new account to connect your database.  1, connect mysql[html] mysql-uroot-p password   (no space after-p, start with password from-p)     if your MySQL is on a remote server, you need to add- Hip addresses, such as  mysql-uroot-p123456-h111.111.111.111   2, view all users in the MySQL database, and carefully check if there are any users without your authorization [html]  SELECT DISTINCT CONCAT (' User: ', user, ' @ ', host, '; ') as query from Mysql.user;   3, create a new user (for a database user) format: Grant permissions on the database. * To username @ Login host identified by "password" such as, add a user user1 password for password1, so that it can log on this computer , and has permissions to query, insert, modify, and delete all databases. First use the root user to connect to MySQL, and then type the following command: [html] grant select,insert,update,delete on * * to [email protected] identified By "Password1";   Note: "localhost" here means that the user can only log on locally and cannot telnet to another machine. If you want to telnet, change "localhost" to "%", which means you can log on on any computer. You can also specify that a machine can log on remotely.   If you do not want to User1 have a password, you can use another command to remove the password. [Html] grant Select,insert,update,delete on mydb.* to [email protected] identified by "";    if the user's originalTo exist, you simply [Html] grant select,insert,update,delete on mydb.* to [email protected]   permission list grant permission 1, permission 2,...  Permission n on the database name. Table name to User name @ user address identified by ' connection password '; Permissions 1, Permissions 2,...  Permission n represents 14 permissions, such as Select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file. When permissions 1, permissions 2,...  Permission n is replaced by all privileges or all to give the user full permission. When the database name is, the table name is replaced by *. * To give the user all the table D permissions on the operation server.  [html] mysql>grant all privileges in testdb.* to [email protected] identified by ' 1234 ';    mysql>flush privileges;//Refresh System Permissions Table   format: Grant permissions on database. * To User name @ login host identified by "password";  4, delete user  @>mysql-u root-p @> password  mysql>delete from user Where user= ' test ' and host= ' localhost ';  mysql>flush privileges; mysql>drop database TestDB;        Delete User's database Delete account and permissions: >drop user username @ '% '; >drop user username @ localhost; 5, modify specified user password   @>mysql-u root-p  @> password   mysql>update mysql.user Set Password=password (' New password ') where User= "Test" and host= "localhost";  mysql>flush privileges; If I delete the SA user, I set the Host to Localhost:[html] drop before User [email protected];

MySQL MySQL Workbench use

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.