If you don’t want the user to have a password (for the password to be blank) then select No Password from the dropdown box. Password: if you want the user to have a password, then leave the selection in the dropdown box as Use text field and enter a password (up to 16 characters, composed of letters and / or digits) into the edit box on the right. Host: since this is for AMPPS, select Local from the dropdown box. It would probably be safest to restrict yourself to lowercase letters, uppercase letters, and / or digits. The MySQL documentation recommends using only ASCII characters in the name. A user name may be a maximum of 16 characters in length. User Name: Leave the dropdown selection as Use text field and enter a user name in the edit box on the right side. Since AMPPS does not give us root privileges for the database, we need to create a user for the database. While the database has been created, it is only accessible by user root. There should be no need to change the other settings:Ĥ) Confirm the database was successfully created (this is a popup that only lasts a few seconds): For example: joomla_database or database_for_drupal. A good name should indicate the purpose of the database. Avoid using numbers at the start of the name. The name must be 64 characters or less and composed of letters, numbers and underscores. Creating a Databaseġ) Open your browser and enter This will bring you to the MySQL setup page:ģ) Enter a name for the database, then click on the Create button. However, if you are installing an application that does not have a setup script provided by AMPPS (and it requires a MySQL database), then you will need to manually create a database.Īs well, if you are writing your own application and require a database, then you will also need to manually create one.
Normally, you would not need to create a database in AMPPS because the setup script will automatically do that for you.