Connect to the MySQL instance manager and create a user account _ MySQL

Source: Internet
Author: User
Connect to the MySQL instance manager and create a user account. use the MySQL client-server protocol to process communications with the MySQL instance manager. You cannot use the standard mysql client program and MySQL c api to connect to IM. IM supports the MySQL client-server protocol version used by client tools and databases distributed by mysql-4.1 or later versions.

IM saves user information to the password file. The default location of the password file is/etc/mysqlmanager. passwd.

The password should be similar:

Petr: * 35110DC9B4D8140F5DE667E28C72DD2597B5C848

To generate a password, use the -- passwd option to call IM. The output can be redirected to the/etc/mysqlmanager. passwd file to add new users. The following is an example command.

./Mysqlmanager -- passwd>/etc/mysqlmanager. passwd
Creating record for new user.
Enter user name: mike
Enter password:
Re-type password:

The following line is added to/etc/mysqlmanager. passwd:

Mike: * 00A51F3F48415C7D4E8908980D443C29C69B60C9

If the file/etc/mysqlmanager. passwd does not exist, the IM cannot be connected.

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.