https://projects.raspberrypi.org/en/pro ... -wordpress
If you have set up Lamp-Wordpress correctly the user name for getting into the MYSQL database will be called "root" and password will be what ever you entered if you followed these instructions in the link above.
User Name= pi , Password = Raspberry
or what ever you have changed it to.
User Name = root Password = (blank = nothing)
or what ever you changed it to during MYSQL database installation.
If you did not provide a password it will be blank and when prompted for a password for the user root, just hit enter.
What ever user you setup during Wordpress installation questionnaire page:i.e hockeykid57 for example
User Name = hockeykid57 and Password = (what ever password you entered during Wordpress installation)
Assuming you got all of that so far...
Go to Application Menu -> Accessories -> Terminal
At the command prompt type
i.e [email protected]
:~ mysql -u root -p
(you will then be prompted for a password) if you haven't setup one just hit enter.
If you have, type it in - (Note: The password will not show anything while you type out the password, this a security measure by design
) next hit enter
You will then be talking to your MYSQL database...in this case it's called MariaDB.
so it might look like this
to get out of it , just type "quit"
if you get stuck with a prompt that looks like ">"
type a semicolon " ; " no quotes and hit enter, then type "quit" no quotes and hit enter - and try logging in again
i.e mysql -u root -p
How to get the database name....
type "show databases;" (hit enter)
MariaDB [(none)]>show databases;
your databases will then be listed in a dotted box below.
and you see the message
You could then use other commands (before you entered "quit"to examine the databases, but I would highly recommend you read more on MYSQL commands before proceeding with any other instructions...
hope that helps