I just verified with my phpmyadmin, that I can login to phpmyadmin using any account defined inside of mysql (they just see different stuff when they login based on their permissions). Second, if I've got it right (and apologies if you already know this) it is important to understand that user accounts inside of mysql are independent of unix accounts. That is the user that the web app will use to access the database. I could not remember how I fixed it until a read wallaroo's post a few times.įirst, don't mess with that phpmyadmin user or its config files (set them back to normal). localhost/phpmyadmin still only works with user = "phpmyadmin" and password set to my accounts password.Īfter a week of banging on this I'm about ready to wipe the hard disk and reinstall Mint20, then apache, then php, then mysql, then phpmyadmin all fron scratch. It will only work if the username is entered as phpmyadmin and the passwordis the password for my account."xyz" I cannot login to localhost/phpmyadmin using my username and my account password. The problem I'm having continues to be that. So I assume mysql thinks its assigned user is "mysql"īut. is a file mysqld.cnf which tells me via cat/mysqld.cnf. This file points me to /etc/mysql/conf.d. Later I looked for the mysql username and password in. show databases Īnd I see the database testdb that I just created. xyzĪnd the mysql prompt appears and I can executive mysql commands.įor instance I created a new database named testdb using. It ask me for a password and I give it my account password. When I'm logged into my new Mint 20 as me. Wallaroo, sorry I'm just getting back to you but I've been chasing this phpmyadmin install for 7 days and gone down countless links. I'm sure this is bad practice but I'm keeping it simple the first time through as I have to do this on a few more machines after this first one. So far it works to let me sign on after the system times out. PS since this is my first Linux install I used the same password I used for Linux Mint for everything else. what is the easiest way to fix this? I've been pounding on for awhile and my brain is fried here late on Friday night. so I assumed it was using my Linux Mint user name. unless it has to do with the phpMyAdmin user name. I can't help but wonder why it won't accept the password I gave during the installing of phpMyAdmin. which has resulted, so far, in adding to the confusion. I've Googled and see a number of different methods to this. When installing phpMyAdmin it asked me for a password and I gave it one.īut when I go to localhost/phpmyadmin on Firefox it won't accept it. I'll be using this system to locally develop, maintain, and debug websites with MySQL databases and with PHP code. I'm a new Linux user and just installed Min 20, Apache server, MySQL, PHP, and phpMyAdmin.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |