Level 73
I've given you this link before but here it comes again.
To setup a LAMP stack on Ubuntu.
https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-on-ubuntu-18-04-lamp/
Dec 25, 2019
4
Level 27
Lampp Ubuntu
I need some guidance on how to use lampp in ubuntu.
I already installed lampp and now I installed phpmyadmin on ubuntu in order to be able to access the phpmyadmin:
ref: https://askubuntu.com/questions/19127/how-to-access-phpmyadmin-after-installation
Now, after installing it and I did not set the password.
I wonder why this login does not works:
username: root password:
I cannot login.
What should I do now?
Level 27
Now, that I already installed the phpmyadmin but couldn't login. I run this command:
t@davy-Nitro-AN515-52:/home/davy# sudo apt-get install phpmyadmin Reading package lists... Done Building dependency tree Reading state information... Done phpmyadmin is already the newest version (4:4.6.6-5). 0 upgraded, 0 newly installed, 0 to remove and 189 not upgraded. root@davy-Nitro-AN515-52:/home/davy# apt-get -y install phpmyadmin Reading package lists... Done Building dependency tree Reading state information... Done phpmyadmin is already the newest version (4:4.6.6-5). 0 upgraded, 0 newly installed, 0 to remove and 189 not upgraded. root@davy-Nitro-AN515-52:/home/davy# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 Server version: 5.7.28-0ubuntu0.18.04.4 (Ubuntu)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'secret'; Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON . TO 'admin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; exit Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
->
Anything wrong?
Level 122
phpmyadmin is a website. You also need apache configured to serve this website
Level 27
I think I did that already. Now, I can opened phpmyadmin but cannot login.
I already tried to remove the current installation and reinstalled but I still cannot login. I wonder why?
mysql> CREATE USER 'admin'@'localhost' IDENTIFIED BY 'secret'; ERROR 1396 (HY000): Operation CREATE USER failed for 'admin'@'localhost' mysql>
I already followed step no. 9
ref: https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-on-ubuntu-18-04-lamp/
Please or to participate in this conversation.