Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to establish a user name in mysql, which can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software.

How does mysql establish a user name?

1.mysql creation Library create database Database name

2.mysql creates users and passwords

Create user username IDENTIFIED by 'user password'

3. Assign library permissions to the user

GRANT ALL ON database name. * TO 'username'

Thank you for reading this article carefully. I hope the editor will share how to establish the user name content of mysql will be helpful to everyone. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.