Cannot create database in phpMyAdmin(XAMPP)

Support AUR
1

What heck is this not being able to put links nor images in a post! I’ll have to disassemble the links below, sorry!

I can’t use phpMyAdmin on my system. There’s a weird kind of double-bind going on.
I installed XAMPP from AUR (issues posted there by other users are not the same as mine. it’s mostly starting the MySQL server, which does work for me).
I am able to start Apache and MySQL, but not getting access to phpMyAdmin:

https:// imgur. com/ 2qPwm8v

I tried the following:
Changed user from root to ben in /opt/lampp/phpmyadmin/config.inc.php

This lets my start phpMyAdmin, but I can’t create a database. I get this message:

https:// imgur. com/ ZoUvtZU

#1044 User “@‘localhost’” has no permission to access database blabla

so there’s a username missing here.
I also posted about it here: https:// discuss.codecademy .com/t/ error-incorrect-database-name/526878/15).

Trying to copy the error message here:

Error
MySQL said:**
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/1698): Access denied for user ‘root’@‘localhost’
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

2

I wonder if XAMPP’s MySQL is somehow conflicting with my repos’ installation of MariaDB.
It turns out MariaDB is installed on my system from official Manjaro repos.
XAMPP is installed from AUR.
However, if I try to remove MariaDB in Pamac, it also wants to remove the XAMPP package, so maybe MariaDB was actually pulled from official repos as a dependency of the AUR XAMPP package (if that even happens at all).

How do I find out if
1.) I have two installations of MariaDB on my system and
2.) That actually causes problems or not?

Checking which mysql I found that all these files exist in /usr/bin:

file:///usr/bin/mysql
file:///usr/bin/mysql_client_test
file:///usr/bin/mysql_client_test_embedded
file:///usr/bin/mysql_config
file:///usr/bin/mysql_convert_table_format
file:///usr/bin/mysql_embedded
file:///usr/bin/mysql_find_rows
file:///usr/bin/mysql_fix_extensions
file:///usr/bin/mysql_install_db
file:///usr/bin/mysql_ldb
file:///usr/bin/mysql_plugin
file:///usr/bin/mysql_secure_installation
file:///usr/bin/mysql_setpermission
file:///usr/bin/mysql_tzinfo_to_sql
file:///usr/bin/mysql_upgrade
file:///usr/bin/mysql_waitpid
file:///usr/bin/mysqlaccess
file:///usr/bin/mysqladmin
file:///usr/bin/mysqlbinlog
file:///usr/bin/mysqlcheck
file:///usr/bin/mysqld
file:///usr/bin/mysqld_multi
file:///usr/bin/mysqld_safe
file:///usr/bin/mysqld_safe_helper
file:///usr/bin/mysqldump
file:///usr/bin/mysqldumpslow
file:///usr/bin/mysqlhotcopy
file:///usr/bin/mysqlimport
file:///usr/bin/mysqlshow
file:///usr/bin/mysqlslap
file:///usr/bin/mysqltest
file:///usr/bin/mysqltest_embedded

also, these:

file:///usr/bin/mariadb
file:///usr/bin/mariadb_config
file:///usr/bin/mariadb-access
file:///usr/bin/mariadb-admin
file:///usr/bin/mariadb-backup
file:///usr/bin/mariadb-binlog
file:///usr/bin/mariadb-check
file:///usr/bin/mariadb-client-test
file:///usr/bin/mariadb-client-test-embedded
file:///usr/bin/mariadb-convert-table-format
file:///usr/bin/mariadb-dump
file:///usr/bin/mariadb-dumpslow
file:///usr/bin/mariadb-embedded
file:///usr/bin/mariadb-find-rows
file:///usr/bin/mariadb-fix-extensions
file:///usr/bin/mariadb-hotcopy
file:///usr/bin/mariadb-import
file:///usr/bin/mariadb-install-db
file:///usr/bin/mariadb-ldb
file:///usr/bin/mariadb-plugin
file:///usr/bin/mariadb-secure-installation
file:///usr/bin/mariadb-service-convert
file:///usr/bin/mariadb-setpermission
file:///usr/bin/mariadb-show
file:///usr/bin/mariadb-slap
file:///usr/bin/mariadb-test
file:///usr/bin/mariadb-test-embedded
file:///usr/bin/mariadb-tzinfo-to-sql
file:///usr/bin/mariadb-upgrade
file:///usr/bin/mariadb-waitpid
file:///usr/bin/mariadbd
file:///usr/bin/mariadbd-multi
file:///usr/bin/mariadbd-safe
file:///usr/bin/mariadbd-safe-helper

…all but 2 of them acutally being symlinks to a mysql file.

3

It is a dependency. Check the AUR Site for XAMPP
https://aur.archlinux.org/packages/xampp/

or use

pacman -Qi xampp

However, I believe using xampp on a Linux system is always the wrong way on running a LAMP Stack. Either learn and configure all required parts manually or use something like docker.

The MySQL commands are part of the MariaDB package. It is necessary for backwards compatibility.

1 Like
4

So that’s a yes to my question?

AUR packages pull dependencies from official repos?

5

Yes, but you should check that yourself. For example with the mentioned pacman command.

Yes of course, this happens all the time. Just not the other way around.