Issue with phpmyAdmin

[Mamunson]

Hi,

I installed PHP 8 and it is showing PHP 8 when I type php -v. I also installed apache2, and phpmyadmin but when I go to http://localhost/phpmyadmin it says Object not found! Error 404

[hui]

There is a thread from 2009 which says that you need to use right spelling with upper-/lowercase…

http://localhost/phpMyAdmin/

phpmyadmin problem

what you did (we prefer with copy/past of the exact statements you typed); I’d installed the phpmyadmin, right?! what you thought that would happen; If I wrote localhost/phpmyadmin to the url, then come up the phpmyadmin page. what did happen instead (again copy/past of (error) messages). Only this error message happened: Object not found! The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again. If you think this is…

[kasi042]

Too slow, again.
Yes, I can confirm this, I just tried it here. Even from the laptop accessing my home server it’s case sensitive.

[Mamunson]

@hui

http://localhost/phpMyAdmin/

My bad Many thanks. I know the user is root but I don’t know the password. I tried typing mysqladmin -u root password 1234 but got:

error: 'Can't connect to local server through socket '/run/mysql/mysql.sock' (2)'
Check that mariadbd is running and that the socket: '/run/mysql/mysql.sock' exists!
verwalter@desktop-Lenovo-ideapad-100-15IBY:~> 

[kasi042]

try pmaUserinstead of root. I don’t exactly know why, but I made a note in my docs that root access doesn’t work. The password needs to be set, IRRC it was in mysql.

Ah, found it. Check here:

Edit:
https://en.opensuse.org/SDB:LAMP_setup#Defining_Admin_User_for_phpMyAdmin

[Mamunson]

This is how far I came:

verwalter@desktop-Lenovo-ideapad-100-15IBY:~> mysql -p -u root
Enter password: 
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
verwalter@desktop-Lenovo-ideapad-100-15IBY:~> CREATE USER 'pmaUser'@localhost IDENTIFIED BY 'pma';
If 'CREATE' is not a typo you can use command-not-found to lookup the package that contains it, like this:
    cnf CREATE
verwalter@desktop-Lenovo-ideapad-100-15IBY:~> CREATE USER 'pmaUser'@localhost IDENTIFIED WITH mysql_native_password AS PASSWORD('pma');
bash: syntax error near unexpected token `('
verwalter@desktop-Lenovo-ideapad-100-15IBY:~> 

[kasi042]

In that case you may better read that SDB from the start, or at least setup of mariadb and mysql. I followed it some time ago, don’t remember the details. I think root access had to be configured, first.

[Mamunson]

I’m getting: mysqli::real_connect(): (HY000/1698): Access denied for user ‘root’@‘localhost’

[kasi042]

Did you follow this?

https://en.opensuse.org/SDB:LAMP_setup#Configuring_the_MariaDB/MySql_server

To configure the MariaDB server with improved security, please use the script 'mysql_secure_installation provided by openSUSE. Hereafter is the description of the full process.

root # mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we’ll need the current
password for the root user. If you’ve just installed MariaDB, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):

(Had to switch to the phone. Sorry must stop for today.)

[Mamunson]

@kasi042

mysql_secure_installation

Awesome, many thanks indeed. It worked! Hurray!

[kasi042]

Glad I could help.