install_apache_mysql_php_linux_ubuntu_server
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
install_apache_mysql_php_linux_ubuntu_server [2020/06/08 18:41] – [Install MySQL Database Server] wikiadmin | install_apache_mysql_php_linux_ubuntu_server [2020/06/08 23:20] (current) – [Create a new admin user or new root user and password with PhpMyAdmin access from any IP remotely] wikiadmin | ||
---|---|---|---|
Line 179: | Line 179: | ||
//LOW Length >= 8// | //LOW Length >= 8// | ||
+ | |||
//MEDIUM Length >= 8, numeric, mixed case, and special characters// | //MEDIUM Length >= 8, numeric, mixed case, and special characters// | ||
+ | |||
//STRONG Length >= 8, numeric, mixed case, special characters and dictionary file// | //STRONG Length >= 8, numeric, mixed case, special characters and dictionary file// | ||
**Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2** | **Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2** | ||
+ | |||
//Please set the password for root here.// | //Please set the password for root here.// | ||
Line 189: | Line 192: | ||
**Re-enter new password:** | **Re-enter new password:** | ||
- | //Estimated strength of the password: 100 | + | //Estimated strength of the password: 100// |
- | Do you wish to continue with the password provided? | + | |
- | By default, a MySQL installation has an anonymous user, | + | **Do you wish to continue with the password provided? |
+ | |||
+ | //By default, a MySQL installation has an anonymous user, | ||
allowing anyone to log into MySQL without having to have | allowing anyone to log into MySQL without having to have | ||
a user account created for them. This is intended only for | a user account created for them. This is intended only for | ||
Line 218: | Line 223: | ||
**Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y** | **Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y** | ||
- | - Dropping test database... | + | |
+ | // - Dropping test database...// | ||
// | // | ||
- | - Removing privileges on test database... | + | ** - Removing privileges on test database...** |
// | // | ||
Line 232: | Line 238: | ||
// | // | ||
+ | |||
+ | //All done!// | ||
</ | </ | ||
+ | ===== Installing phpMyAdmin ===== | ||
+ | |||
+ | phpMyAdmin is a web interface to manage MySQL databases and user privileges. | ||
+ | |||
+ | < | ||
+ | |||
+ | When prompted during installation, | ||
+ | |||
+ | When prompted to create the phpMyAdmin database, provide your admin user access details and take the remaining steps to complete the installation. | ||
+ | |||
+ | ===== Workaround Errors in setting up phpmyadmin@localhost with all privileges involving dbconfig-common ===== | ||
+ | |||
+ | |||
+ | Are you getting errors when trying to login to PhpMyAdmin as root? | ||
+ | |||
+ | < | ||
+ | Cannot log in to the MySQL server | ||
+ | |||
+ | mysqli_real_connect(): | ||
+ | |||
+ | Connection for controluser as defined in your configuration failed. | ||
+ | |||
+ | mysqli_real_connect(): | ||
+ | |||
+ | or | ||
+ | |||
+ | #1698 - Access denied for user ' | ||
+ | </ | ||
+ | ==== Create a new PhpMyAdmin root user and password having PhpMyAdmin access from any IP remotely ==== | ||
+ | |||
+ | Using SSH access to the Ubuntu Server, log into the mysql console using as the MySQL user ' | ||
+ | |||
+ | < | ||
+ | sudo mysql -u root -p | ||
+ | </ | ||
+ | |||
+ | **Enter password:** | ||
+ | |||
+ | The SSH prompt should change to the MySQL console prompt that looks like this: | ||
+ | |||
+ | < | ||
+ | |||
+ | Now, create a new MySQL admin/root user with all privileges including GRANT privileges and make sure that the user can login from any IP remotely rather than only having privileges from @localhost. There are 3 choices of commands in the code block below for creating a new user from the MySQL console prompt; however, only the third choice may actually allow for logging into PhpMyAdmin as a root user from any remote IP. | ||
+ | |||
+ | < | ||
+ | CREATE USER ' | ||
+ | |||
+ | CREATE USER ' | ||
+ | |||
+ | CREATE USER ' | ||
+ | </ | ||
+ | |||
+ | So, for example, this should work (and ensure that you are logged into the console prompt at mysql> | ||
+ | |||
+ | < | ||
+ | CREATE USER ' | ||
+ | |||
+ | </ | ||
+ | |||
+ | Now, let's grant the new user named ' | ||
+ | |||
+ | < | ||
+ | GRANT ALL PRIVILEGES ON *.* TO ' | ||
+ | </ | ||
+ | |||
+ | And lastly, run this command: | ||
+ | < | ||
+ | FLUSH PRIVILEGES; | ||
+ | </ | ||
+ | Exit the MySQL console and return to the SSH user prompt, with the exit command: | ||
+ | < | ||
+ | Now, open your web browser and log into PhpMyAdmin through a webpage on a remote device with the username ' | ||
install_apache_mysql_php_linux_ubuntu_server.1591641673.txt.gz · Last modified: 2020/06/08 18:41 by wikiadmin