Can't see to log into phpMyadmin for first time with root and my password

Keywords: LAPP/MAPP/WAPP - Amazon Web Services - Technical issue - Credentials
Description:
for the first time. I browse to 127.0.0.1:\phpmyadmin. The phpmyadmin login screen appears. I use root as the username. For the password I use the code that is generated by cat bitnami_application_password. I copy this with ctrl-c and then paste it into the password field. I have also tried typing it in manually.

I get “Cannot log in to the MySQL server”. Am I using the wrong password?

Hi @richb201,

Thank you for using Bitnami. Could you please let us know more information about your deployment?

  • Are you using the Bitnami LAPP or LAMP stack? Please note that the first one includes PostgreSQL and phpPgAdmin and the second one includes MySQL and phpMyAdmin.
  • Can you access the database using the command line?

PostgreSQL: https://docs.bitnami.com/aws/components/postgresql/#how-to-connect-to-the-postgresql-database
MySQL: https://docs.bitnami.com/aws/components/mysql/#how-to-connect-to-the-mysql-database

Thanks

Thanks Jota. I am using LAMP. I think phpmyadmin is running since I can see the login screen. Here is a screen shot:

<img

This is really a password problem, As I stated, I got the password from cat bitnami_application_password. Here is a screen shot of that as well. Well, this forum won’t let me post that (only one image).

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

No entry for terminal type “xterm”;
using dumb terminal settings.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql>

So I am able to get in via the command line.
Now what?

I am having the same problem with a Wordpress Instance. The password I get from cat ./bitnami_credentials doesn’t work.

What now?

I have even reset the password via the command line.
mysql> SET PASSWORD FOR ‘root’@‘localhost’= PASSWORD(‘xxxxxxxx’);

This ran OK. But when I go to 127.0.0.1/phpmyadmin in the browser and try
using root and xxxxxxxx, it fails. What’s up?

Hi @richb201,

Regarding WordPress, where did you launch it? We launched a WordPress image from the AWS marketplace and it worked perfectly. The password is the one mentioned in the /home/bitnami/bitnami_credentials file.

Also, we ran the exact same command you posted above, and it worked perfectly for us. When logging in to phpMyAdmin, the password is ‘xxxxxxxx’. In fact, when running the “mysql” command for entering the CLI console, the password is ‘xxxxxxxx’ as well.

Are you running these commands from the instance where phpMyAdmin is installed?

Yes, I did that exact thing. The fact that I can’t “login” to either the Wordpress or the LAMP AWS instances with the same password is frustrating. I AM able to get in via the command line. BUT what does that do for me?

cat ./bitnami_credentials


The default password is ‘zxxxxxx’.


I have tried copy and pasting that password. I have also tried typing it in on the keyboard (about a hundred times). I am starting to think that it may be a putty configuration issue?

Is there anyway to see exactly what the communication between my copy of putty is and the lightsail instance? I am using a secure tunnel so I doubt it. Please advise.

I just realized that maybe i am trying to log into the wrong copy of
phpmyadmin. I have XAMPP installed locally on my PC for development and
testing. I access phpmyadmin by clikcing on the XAMPP control panel mySQL,
admin. When I am trying to get to the phpmyadmin on my lightsail instance,
I type 127.0.0.1/phpmyadmin isn’t this localhost??? This could be the
reason that my AWS password doesn’t work. How can I get to the AWS
phpmyadmin other than going through localhost???

Hi @richb201, I’m glad you were able to identify why you were not being able to connect properly.

In order to connect to the phpMyAdmin offered by Bitnami images, you can follow these instructions: https://docs.bitnami.com/aws/apps/redmine/operating/access_phpmyadmin/

I hope it works now!

still can’t get it working. I am going to log in from another PC (after opening and ssh tunnel) and see if it works. Can you guys test to see if you can get into it with the default password?

This is getting silly. Here are the facts. Please come up with a way I can debug this issue (ie network sniffer), whatever, I will try it.

  1. I have created a new LAMP instance on Lightsail
  2. I created a new Wordpress instance on Lightsail
  3. I have gotten my password via cat ./bitnami_credentials
  4. I can log into phpMy Admin via the CLI in putty
  5. I open a browser window and type 127.0.0.1/phpMyAdmin. I use “user” and the password from bitnami_credentials. I get " Cannot log in to the MySQL server".
  6. I also can’t use the password I got to log into the wordpress instance.

Can you guys please give me some ideas??

I think I might have gotten in. I am not really sure because the myphpdmin on my localhost and the bitnami one on lightsail look the same. Is there someway to tell if I am connected to the right one?

Under webserver in the AWS one it says:

Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.28
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP extension: mysqli Documentation
PHP version: 5.6.28

under webserver on my local PC it says:

Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.28
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
PHP extension: mysqli Documentation
PHP version: 5.6.28

since the id’s are identical I can only assume that I am still using my local server.

Hi @richb201, how are you creating the SSH tunnel? Usually you would need to specify a port different than 80.

In the guide I sent earlier, you are indicated to use port 8888 (which maps to the instance’s port 80), therefore if you followed that guide, in your Windows machine you need to connect to this URL:

http://localhost:8888/phpmyadmin

So I think I might have gotten into the bitnami phpMyadmin on the AWS. My next task is to copy my database from my own phpMyAdin to the bitnami phpMyAdmin. I created a copy of my database by using Export in my local copy. I put this created file on my desktop. Now I go into the bitnami phpmyadmin and go to the import tab. I go to

File to import:
File may be compressed (gzip, bzip2, zip) or uncompressed.
A compressed file’s name must end in .[format].[compression]. Example: .sql.zip

Browse your computer:(Max: 80MiB)
You may also drag and drop a file on any page.

The choices all seem to be on my local hard drive instead of the drive on the server.
What am I doing wrong???

BTW, shoould I be accessing the Mysql on my lightsail instance from my local phpmyadmin on my PC? Is this the normal way of doing it?

Well I managed to get Wordpress working on a separate wordpress instance. I used the same password that will not work on 127.0.0.1:8888/phpmyadmin. On the phpadmin I have tried both root and password and also root@localhost and password. Neither work. I have uninstalled and reinstalled at least 5 times. following every word in the instructs. The password just doesn’t work. I tried all different methods of removing the password, but I don’t have the linux skills. Since I am pretty sure that I have followed your written instructions 4 or 5 times, can you give me an idea of what to do?

Hi @richb201,

You should be accessing phpMyAdmin from the instances you launched. In order to access it from your PC, you need to create the SSH tunnel, and as an example, forward remote port 80 to local port 8888.
This way, when you access port 8888 locally, you’re really accessing port 80 from the remote instance.

My take is that you are not properly creating the SSH tunnel. If you are using Windows, there is a video on how to create the SSH tunnel and connect to phpMyAdmin here: https://docs.bitnami.com/aws/apps/redmine/operating/access_phpmyadmin/

https://www.youtube.com/watch?v=9VdcQLDmYII

Have you tried following those steps?

Yes. I have even reviewed the putty log to make sure all went OK. It did.

Hi @richb201,

Before, we believe to have misread this, which is not actually an issue:

The choices all seem to be on my local hard drive instead of the drive on the server.
What am I doing wrong???

Note that the “Explore file” dialog will always be looking for files in your local computer hard disk. That is because of how the web browser works.

Next, we’re a bit confused over what issues you are currently getting. Could you describe what you intend to do and what errors you get? For example, something like this:

  • Local computer: Contains phpMyAdmin, but I’m not using it.
  • Server 1: Contains WordPress and phpMyAdmin. I create the tunnel to port 8888, and when accessing with my web browser at localhost:8888/phpmyadmin, using password for server 1 (user/password1), I can log in to phpMyAdmin.
  • Server 2: Contains a new WordPress installation which I want to migrate data to. I created a tunnel to port 9999 and access at localhost:9999/phpmyadmin, but I cannot log into its phpMyAdmin because the credentials (user/password2) are wrong.

Thanks!