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
