wpondeb990

@a2hostingrj – I am at the mercy of the command line in MariaDB for management.

I have plenty of experience with building, supporting and upgrading Windows servers, but only a bit of experience with Linux. I have been anxious to setup a LAMP system for a number of years. I chose Debian v9.9.0 (Stretch) on recommendation of a colleague with the intent of providing a solid foundation for WordPress. The LAMP installation went reasonably well, with only minor errors or problems that were easily overcome.

The installation of WordPress also went well until I got to the point of testing the DB connection on the setup page, where I got stuck.

I did create the Database, etc. using:
MariaDB [(none)]> CREATE USER ‘wpuser’@’localhost’ IDENTIFIED BY ‘userpassword’;
MariaDB [(none)]> CREATE DATABASE wp_database;
MariaDB [(none)]> GRANT ALL ON wp_database.* TO wpuser@localhost;
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit;

I substituted ‘wpuser’ with another.
I substituted ‘localhost’ with my (Debian) machine name.
I substituted ‘userpassword’ with another.

From the Windows computer running the browser to complete the WordPress setup, it can ping [by machine name] the Debian server where WordPress is installed (on local network).

I cannot tell what I did wrong. I would like to do this part over again, but I do not know how to get rid of the database I now have or how to fix it.