Database access using the MySQL® DBMS:
Contents
- Overview
- Basic MySQL DBMS client configuration
- Changing MySQL DBMS password using the MySQL terminal monitor
- Summary
- Additional Notes
Overview
Access to the MySQL® database management system (DBMS) is available to all users of Nixsys PAUS. Permission to utilize MySQL database DBMS capabilities is granted upon request. These accounts are not available by default, because the MySQL database server requires a different password than the one used for all other Nixsys PAUS resources. The character set for the MySQL database server is UTF-8 and the collation is UTF-8 General. Keep this in mind when creating tables and when it's necessary to use a different character set and / or collation.
Basic MySQL DBMS client configuration
| Hostname | Username | Password | Database Name |
|---|---|---|---|
| localhost | Nixsys PAUS username | Something temporary | User Specified |
From the above table, connections can only be made to "localhost". Users can not connect to the MySQL database server remotely. By default, the username used to connect to the MySQL DBMS is the same username needed to access all other Nixsys PAUS resources. Users have the privilege to request a different username (16 characters maximum) for MySQL DBMS access. Having a different username, which can be twice (2x) as long as the Nixsys PAUS username, is arguably more secure than having the same username for both purposes.
Upon requesting access to the MySQL DBMS, users must supply the administrator with a temporary password used to create and secure the account. When users login to MySQL, it is recommended they change the password on their MySQL DBMS accounts to something relatively unique. Passwords can be a maximum length of sixty four (64) characters. Random strings of uppercase, lowercase, numbers, and special characters are recommended for better account security.
When requesting an account, users must also supply the administrator with the desired name of the database. This value is unchangeable. The length of this name may be no longer than sixty four (64) characters. Random strings of uppercase, lowercase, numbers, and special characters are recommended for better account security.
Changing MySQL DBMS password using the MySQL terminal monitor
- Login to Nixsys PAUS using a SSH terminal.
- At the prompt, type: mysql -u YOU -p, where YOU is your MySQL DBMS username.
- Enter your MySQL DBMS password.
- At the MySQL terminal monitor prompt, mysql>, type: SET PASSWORD = PASSWORD('supersecret');, where 'supersecret' is a random string of uppercase, lowercase, numbers, and special characters no longer than sixty four (64) characters.
Summary
- Overview
- MySQL DBMS access is available upon request to the administrator.
- The MySQL database server requires a different password than Nixsys PAUS accounts.
- The character set for the MySQL database server is UTF-8 and the collation is UTF-8 General. Your tables may need a different character set and / or collation.
- Basic MySQL DBMS client configuration
- Hostname: localhost
- Username: Nixsys PAUS username (default; can be changed. 16 char max)
- Password: Something temporary. Changed later by user. 64 char max.
- Database Name: User specified. Can not be changed. 64 char max.
- Changing MySQL DBMS password using the MySQL terminal monitor
Additional Notes
Please view the MySQL Reference Manual for the complete documentation before e-mailing the administrator of Nixsys PAUS with any questions.
Nixsys PAUS is not affiliated with the authors of the MySQL DBMS or the MySQL database server. MySQL and the MySQL Logo are registered trademarks of MySQL AB in the United States, the European Union, and other countries.
