Nixsys Public Access UNIX System

Database access using the MySQL® DBMS:

Contents

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

MySQL DBMS Connection Parameters Table
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

  1. Login to Nixsys PAUS using a SSH terminal.
  2. At the prompt, type: mysql -u YOU -p, where YOU is your MySQL DBMS username.
  3. Enter your MySQL DBMS password.
  4. 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

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.


Powered by MySQL

Back to the top!