I am running a brand new Aurora R4 on Win 7 Ultra. The AlienFX work most of the time as far as changing color profiles. However they suddenly stopped working, I restarted, reinstalled command center and checked the connections inside the case.

I want to have another user with the same permissions as the master user for my Amazon Relational Database Service (Amazon RDS) or Amazon Aurora MySQL DB instance. How do I duplicate or clone the master user?

Alienware Aurora R4 Software

• Alienware User Support: Powered by Create your own unique website with customizable templates. Alienware User Support.
• Congratulations on the purchase of your Alienware® Aurora! Read all safety and setup instructions before connecting your new desktop. 4 Optical drive bays (2) — Can support additional optical drive(s). 5 Drive panel — Covers the optical drive(s) or optical drive bay(s).
• Alienware User Support: Alienware Aurora ALX. The Alienware Aurora ALX comes with an Intel X58 microATX motherboard which supports up to 24gb of triple channel ddr3 ram via 6 slots. This motherboard supports 240 pin 1.5v ram with timings of 9,9,9,24.

Resolution

An RDS DB instance that runs MySQL can have only one master user, but it's possible to create a new user that has all the same permissions as the master user. To create a new user that has master permissions, follow these steps:

1. Run the SHOW GRANTS command to get a list of the permissions currently available to the master user, and copy that list of permissions to use later:

The command provides output similar to the following:

Note: In the command above, the master user has the user name master_user.

2. Create a new user by running the CREATE USER command:

Note: Replace new_master_user and password with your user name and password.

Alienware Aurora R4 Motherboard

3. Grant the list of permissions you got in step 1 to the new user by running the GRANT command:

Alienware Aurora R4 Motherboard Upgrade

The new user now has the same permissions as the master user.

Related information

How do I allow users to connect to Amazon RDS with IAM credentials?

Related Videos

Aurora PostgreSQL support for Kerberos and Microsoft Active Directory provides the benefits of single sign-on and centralized authentication of Aurora PostgreSQL Database users. Keeping all of your user credentials in the same Active Directory will save you time and effort as you will now have a centralized place for storing and managing them for multiple DB instances.
With this feature, in addition to password-based and IAM based authentication methods, you can now authenticate using AWS Managed Microsoft AD Service. You can enable your database users to authenticate against Aurora PostgreSQL using the credentials stored in the AWS Directory Service for Microsoft Active Directory. You can use the same Active Directory for different VPCs within the same AWS region. You can also join Aurora PostgreSQL instances to shared Active Directory domains owned by different accounts.
Active Directory integration is supported with Aurora PostgreSQL versions 10.11 and newer, and 11.6 and newer.
Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better performance than the typical MySQL database and three times the performance of the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page.