Mysql users and accounts -- (mysql 2)

Source: Internet
Author: User

Mysql user and account -- (mysql 2) The client must provide the username, password, and network string to connect to oracle. the mysql client must provide the account and password to connect to the server. account = username @ ip; creating a user creates an account instead of creating a user. Deleting A uesr also deletes an account. Root is the user name, and root @ loaclhost is the account name. 2. You can use mysql -- help to view the loading path strength of the mysql parameter file ;. input is used only in mysql>.) The large file content can be divided into two parts: mysqld and other 3. Common parameters: \ G \ g and ';': equivalent \ c: cancel \ q and exit: equivalent display format:-B,-t,-X,-H status view database settings, view character set. Source is equivalent to oracle @, and SQL is executed in file mode. set password for 'root' @ 'localhost' = password ('oracle '); Modify and set the account password. 4. in oracle, schame indicates that the set of objects under an account is equivalent to the mysql database;

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: info-contact@alibabacloud.com 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.