|
Post by Powderjockey on Sept 5, 2019 17:07:56 GMT -8
Having trouble getting in to the phpmyadmin site. The log is where I'm stumped. I have tried numerous different log ins and I can't seem to get in. I have uninstalled and re-installed, creating a root password during the installation. When I go to log in, it advises the password is wrong.
This is not a SDL created SD card.
mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
Any suggestions on where to start poking?
Thanks
|
|
|
Post by SDL on Sept 6, 2019 6:27:35 GMT -8
Well, first thing is to try using "admin" and your password. For some unknown reason, phpmyadmin seems to like "admin" sometimes.
BP
|
|
|
Post by Powderjockey on Sept 6, 2019 17:37:06 GMT -8
Well, first thing is to try using "admin" and your password. For some unknown reason, phpmyadmin seems to like "admin" sometimes. BP OK, I've tried root, admin, administrator, pi all as users. I've tried password, "my Password", pi's password, root, nothing in the field for passwords.
|
|
|
Post by SDL on Sept 10, 2019 12:50:02 GMT -8
Hmm. And you have uninstalled and installed it again? Have you looked on how to change the phpmyadmin password from outside of the software?
BP
|
|
|
Post by Powderjockey on Sept 10, 2019 17:12:54 GMT -8
Hmm. And you have uninstalled and installed it again? Have you looked on how to change the phpmyadmin password from outside of the software? BP I will research it and play with it. I always seem to find stuff on changing passwords for mysql.
|
|
impactoz
Full Member
Posts: 142
Raspberry Pi: Yes
|
Post by impactoz on Sept 10, 2019 20:43:13 GMT -8
|
|
|
Post by Powderjockey on Sept 11, 2019 19:01:00 GMT -8
Gave another stab at the removing and re-installing routine. I place a password during the time of the installation, but that password seems to do nothing. Tried the admin, no password; root, no password; and then a host of others.
I'll head over to pipmypi. I have a followed his post and books and seems to have easy step by step for this.
Very frustrating.
|
|
|
Post by SDL on Sept 12, 2019 10:54:45 GMT -8
Indeed. I have installed phpmyadmin many times over the years and about 20% of the time I have problems.
BP
|
|
|
Post by Powderjockey on Sept 12, 2019 15:31:39 GMT -8
Indeed. I have installed phpmyadmin many times over the years and about 20% of the time I have problems. BP Is there any alternative?
|
|
|
Post by doxidad on Sept 13, 2019 3:46:40 GMT -8
I may have missed this - did create a root password in MariaDB? If you didn't and are trying to use phpmyadmin - that could be your problem. The fork of mysql (Maria) doesn't ask you to create a root password. You must create it manually. See articles on creating root password on MariaDB
|
|
|
Post by Powderjockey on Sept 13, 2019 17:35:51 GMT -8
I did do this sudo mysqladmin -u root password 'password', password is not password.
Now, this password that I created does not provide access to phpmyadmin as root.
|
|
|
Post by SDL on Sept 13, 2019 18:16:28 GMT -8
I agree with Doxidad, I seem to remember a problem with Maria and phpmyadmin. Was that where you got the above command?
BP
|
|
|
Post by doxidad on Sept 14, 2019 4:53:06 GMT -8
Did you run this script after you installed mysql? => sudo mysql_secure_installation
This sets up a bunch of security things and prompts you to enter the root password.
I have to comment that the fork of mysql (maria) installation made it hard for one to just install it and use it like you used to be able to do before the fork (like prompting for a root password when installing) - Not sure why they made it more difficult - I'm sure there is a reason and it may have to due with forking from the the Oracle (now owned) mysql.
If you are still having problems you may want to uninstall phpmyadmin and mysql. Reinstall mysql and run the above script to setup security and prompt for a root password and then reinstall phpmyadmin.
I just recently created a new system from scratch and it worked for me.
|
|
|
Post by Powderjockey on Sept 14, 2019 8:37:32 GMT -8
Did you run this script after you installed mysql? => sudo mysql_secure_installation This sets up a bunch of security things and prompts you to enter the root password. I have to comment that the fork of mysql (maria) installation made it hard for one to just install it and use it like you used to be able to do before the fork (like prompting for a root password when installing) - Not sure why they made it more difficult - I'm sure there is a reason and it may have to due with forking from the the Oracle (now owned) mysql. If you are still having problems you may want to uninstall phpmyadmin and mysql. Reinstall mysql and run the above script to setup security and prompt for a root password and then reinstall phpmyadmin. I just recently created a new system from scratch and it worked for me. yes. OK, I will uninstall both phpmyadmin and mysql and try again. I have used this tutorial in the past pimylifeup.com/raspberry-pi-phpmyadmin/ and it has work just fine.
|
|
|
Post by Powderjockey on Sept 15, 2019 15:36:37 GMT -8
OK, I got it to installed again. Inserted the password where required. Once again, none of the passwords worked.
So, I did the following
sudo mysql -u root -p GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password';
This now allows me to access the phpmyadmin.
But, as I go run the SkyWeather script, I get the following error.
sudo python SkyWeather.py Traceback (most recent call last): File "SkyWeather.py", line 37, in <module> import pclogging File "/home/pi/SDL_Pi_SkyWeather/pclogging.py", line 28, in <module> import MySQLdb as mdb ImportError: No module named MySQLdb
|
|