Dear Sir,
I follow your instructions to install phpmyadmin and changed the password accordingly.
When i open in browser and key in user: root and password: mypassword
the below message appears that my password is wrong.
#1698 – Access denied for user ‘root’@’localhost’
what should i do now? your help is much appreciated.
Hello, can you create a new user for your database instead of root? Like admin?
Here’s the updated guide: Raspberry Pi: Install Apache + MySQL + PHP (LAMP Server)
https://randomnerdtutorials.com/raspberry-pi-apache-mysql-php-lamp-server/
Run this command in your terminal window:
sudo mysql --user=root --password create user admin@localhost identified by 'your_password'; grant all privileges on *.* to admin@localhost; FLUSH PRIVILEGES; exit;
Those commands will create a new user with name (admin) and password (your_password).
Let me know if this solves your problem! Regards,
Rui
Thank you, Mr Santos. Able to login using admin and mypassword.
How do I set up raspberrypi access using WiFi instead of Lan network? Thank you in advance for your advise.