Install phpmyadmin on linux

@davy_yg It looks like you stopped the mysql service then tried accessing mysql.

Probably try restarting mysql.

davy@davy-Aspire-E5-476G:~$ sudo /etc/init.d/mysql start [ ok ] Starting mysql (via systemctl): mysql.service. davy@davy-Aspire-E5-476G:~$ mysql -u root ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I don't know the password. I don't remember setting it up.

Try this command with sudo

sudo mysql -u root

It works but then I get stuck on this:

mysql> mysql> CREATE USER 'phpmyadminuser'@'localhost' IDENTIFIED BY 'password'
        '> 
        '> ;
        '> exit
        '> 
        '> \c

I forget to type 'password';

Now, what should I do?

ref: https://www.ostechnix.com/install-phpmyadmin-with-lamp-stack-on-ubuntu-18-04-lts/

Remove user and try again

DROP USER 'phpmyadminuser'@'localhost';

I am curious BTW. Any reason to choose phpmyadmin, instead of an installable database manager like dbeaver or heidisql?

This is what I did:

'> DROP USER 'phpmyadminuser'@'localhost';
    '> 
    '> CREATE USER 'phpmyadminuser'@'localhost' IDENTIFIED BY 'password';
    '> exit
    '> exit();
    '> 

How to exit from mysql> ?

I thought having phpmyadmin is a must to manage the database, just like in windows xampp. heidisql only an addition or helping tools.

It is just a manager that can be used over the internet (therefor popular for hosting providers). As your database is local, you don't need to manage via a website.

Type exit

I already follow the step in the tutorial:

ref: https://www.ostechnix.com/install-phpmyadmin-with-lamp-stack-on-ubuntu-18-04-lts/

http://192.168.0.102/phpmyadmin

Not Found

The requested URL was not found on this server. Apache/2.4.29 (Ubuntu) Server at 192.168.0.102 Port 80

I wonder why?

Install xampp is come in the package. Uninstall any previous apps that will conflict.

the php file info.php already works. but I want to see the database management. I normally use phpmyadmin xampp in Windows. What about in Linux lampp ? I think they should have phpmyadmin works in lampp ?

It is not part of the stack as there are many database managers and you are free to choose the one you want. Personally I use dbeaver on Linux as it works with all kinds of databases

which database manager would you recommend for lampp? I am having a difficult time installing phpmyadmin in lampp.

@armancodes mentioned a few. Personally I prefer dbeaver. Be aware. Table plus is only alpha for Linux as far as I know

I downloaded dbeaver for linux:

ref: https://dbeaver.io/download/

the zip file and extract the file yet, still confuse how to install it.

Just run this command

sudo snap install dbeaver-ce

I created a sample database and get this message:

Access denied for user 'root'@'localhost'

Yeah you need to logon using the user you created. Remember that you cannot login using root without being sudo :)

I open the beaver software by clicking it in software menu.

Then, I try to become sudo in terminal:

davy@davy-Aspire-E5-476G:~$ su - Password: su: Authentication failure

Yet, I have an authentication failure. Any clue why? I don't know my root password.

Don't change your user to root. Create a new user that you want to use for stuff using the procedure you covered yourself earlier. Then use that user to login to dbeaver :)

Why do you need to install any of this on the server?

Just install on your local system (phpmyadmin, navicat, sequel pro, whatever) and add a remote database (your server) to connect to. Keep it on your mac or windows or whatever you're using and leave the actual server alone. Just manage it remotely.

You can manage all of your remote mysql instances on all of your various servers from the same local interface.

I get this message:

https://drive.google.com/file/d/1GghVeeiupEfHZ1XL3APKbPUTPan5J7Ih/view?usp=sharing

This is all in my laptop localhost. I have dual os - linux and windows. Now, I am using linux. I can switch to windows anytime.

Can you not use root as the user and nothing as the password?

I tested creating a new database with usertest as the username and has a password. It is also :

Access denied for user 'usertest'@'localhost' (using password: YES)

I wonder if this dbeaver software is connecting to phpmyadmin so that whenever the username and password is not the same then an access denied message appears?

Again.. phpmyadmin is a database management tool.. Not the actual database. DBeaver connects to your database directly.

Anyways. Right click the connection and select Edit connection. Now change the User name and Password fields https://imgur.com/mAiT1z2

The default is username: root and password: root

correct?

Also, I cannot find the edit connection option. Where to find this option?

Always I suggest digitalocean link for installation. Here is the link, please follow this

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-16-04