LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-20-2019, 10:34 AM   #1
Steve R.
Member
 
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Ubuntu 16.04
Posts: 397

Rep: Reputation: 73
Any Known Issues With Installing PhpMyAdmin with mariadb or mysql?


A few days ago, the installation of PhpMyAdmin "blew-up" my installation of mariabd. Whether PhpMyAdmin was the actual cause or not, I do not know.

What made this particularly irritating is that simply uninstalling PhpMyAdmin did not make the mariadb accessible again. Simply uninstalling and reinstalling mariadb did not work either.

Now, after carefully following some installation tutorials, I have finally gotten back to the point where mariadb, php, and apache2 appear to be behaving correctly. Before attempting the final step of installing PhpMyAdmin with the possibility that it might "blow-up" again; does anyone know of any compatibility issues between PhpMyAdmin and mariadb before I take this final step over the cliff?

For now, I will be using the terminal/command line.

------------------------------------------

Mint 19.2
mariadb version: 10.1.41
php version: 7.3.8
apache2: 2.4.29

With this last round, I limited my package installation, (to the extent possible) to the packages found on the Mint repository.

Last edited by Steve R.; 08-20-2019 at 02:48 PM.
 
Old 08-20-2019, 08:22 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 15,444
Blog Entries: 25

Rep: Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447Reputation: 4447
It's on my VPS at my hosting provider, but I use phpMyAdmin with MySQL several times a week and have done so for years. Before that, when I had shared hosting, again, no issues. Before that, when I self-hosted (years ago), no issues.
 
Old 08-20-2019, 08:27 PM   #3
scasey
Senior Member
 
Registered: Feb 2013
Location: Tucson, AZ, USA
Distribution: CentOS 7.6
Posts: 3,811

Rep: Reputation: 1281Reputation: 1281Reputation: 1281Reputation: 1281Reputation: 1281Reputation: 1281Reputation: 1281Reputation: 1281Reputation: 1281
I've had no problems with phpmysql. Note that the version selected needs to match both the version of php and the version of mysql/mariadb being run, as I recall.

Pay careful attention to those dependencies...
 
Old 08-20-2019, 10:06 PM   #4
phil.d.g
Senior Member
 
Registered: Oct 2004
Posts: 1,261

Rep: Reputation: 134Reputation: 134
I can't offer you anything to prevent you falling over the edge. The only thing I will say is, if it does "blow-up" again then don't rush into starting over. Attempt to troubleshoot the problem, the cause of the "blow up". The primary method of doing this will be looking at logs for errors. Post back here to seek guidance and answers to questions on how to do that troubleshooting.

You'll probably find it's only a pothole, not a cliff.
 
Old 08-21-2019, 07:03 AM   #5
Steve R.
Member
 
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Ubuntu 16.04
Posts: 397

Original Poster
Rep: Reputation: 73
Now that I have had some time to think about this; my drive has plenty of space so I will create a new partition and install a new install of Mint I will focus on simply getting mariadb, apache2, php, and phpmyadmin working. We will be out-of-town for a few days, so it will be a while.

The last time that I installed mysql and phpmyadmin was approximately six years ago. No issues. I then "dropped in" mariadb to replace mysql. Again no issues. Anyway my computer was getting a bit aged so I bought a new one.

Thanks for responding. That more or less confirms that I made a mistake somewhere along the installation process.
 
Old 08-21-2019, 04:56 PM   #6
Steve R.
Member
 
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Ubuntu 16.04
Posts: 397

Original Poster
Rep: Reputation: 73
Partial success. I created a (temporary) test platform and I was able to get PhpMyAdmin to work with mariadb.

However, when I attempted it on my main partition, the installation of PhpMyAdmin failed. Even though it failed, my ability to log into my mariadb still works.

So I will still be plugging away at it. Finally got a useful error message: "Version check failed. Got the following error when calling the 'mysql' command line". So far have not located a post with this issue and how to fix.

As a quickie solution, I purged mariadb and reloaded it. But that did no solve the problem. Is there another place in Linux were an official version number is kept?

Quote:
steve@Alcor:~$ sudo systemctl status mariadb
● mariadb.service - MariaDB 10.1.41 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Wed 2019-08-21 19:12:36 EDT; 14min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 23444 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 27 (limit: 4915)
CGroup: /system.slice/mariadb.service
└─23444 /usr/sbin/mysqld

Aug 21 19:12:34 Alcor systemd[1]: Starting MariaDB 10.1.41 database server...
Aug 21 19:12:35 Alcor mysqld[23444]: 2019-08-21 19:12:35 140118483258496 [Note] /usr/sbin/mysqld (mysqld 10.1.41-MariaDB-0ubuntu0.18.04.1)
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: Looking for 'mysql' as: /usr/bin/mysql
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: Version check failed. Got the following error when calling the 'mysql' command line
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: FATAL ERROR: Upgrade failed
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23487]: Checking for insecure root accounts.
Aug 21 19:12:36 Alcor systemd[1]: Started MariaDB 10.1.41 database server.

Last edited by Steve R.; 08-21-2019 at 06:41 PM.
 
Old 08-22-2019, 03:02 PM   #7
Steve R.
Member
 
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Ubuntu 16.04
Posts: 397

Original Poster
Rep: Reputation: 73
Re-Installed Mint 19.2 to Resoolve PhpMyAdmin Installation

Success. I decided to deploy the nuclear option and made a new install of Mint19.2. My initial install was "fresh" in the sense that I was installing it on a new computer. Much still remains, but none of what is left to be installed presented any problems with the prior install. Nevertheless, it will be a slow tedious process.

I found this website to have one of the better tutorials: Install phpMyadmin, Apache2 and PHP 7.3 on Ubuntu. Many of the websites that I ran across for making this installation are now a bit dated.

A minor footnote point: The following text: "Include /etc/phpmyadmin/apache.conf" needs to be included in the file: "/etc/apache2/apache2.conf", otherwise PhpMyAdmin does not show-up under "localhost/phpadmin".

Last edited by Steve R.; 08-27-2019 at 12:54 PM. Reason: Fix Broken Link
 
Old 08-22-2019, 04:39 PM   #8
phil.d.g
Senior Member
 
Registered: Oct 2004
Posts: 1,261

Rep: Reputation: 134Reputation: 134
Quote:
Originally Posted by Steve R. View Post
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: Version check failed. Got the following error when calling the 'mysql' command line
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Aug 21 19:12:35 Alcor /etc/mysql/debian-start[23477]: FATAL ERROR: Upgrade failed
The Version check failed because the script that does the sanity/verification checks does not know the root user password. To be honest I thought those scripts used a user other than root. Perhaps I'm wrong. However, I imagine you've changed the root password for the DB (as you should), but not updated the scripts configuration. I would disable that script so that I don't need to write the password down.

The third line. What upgrade is that? Potentially that is why phpMyAdmin is struggling.

It would've been useful to see the phpMyAdmin logs.

It's all irrelevant now, anyway.
 
Old 08-22-2019, 06:54 PM   #9
Steve R.
Member
 
Registered: Jun 2009
Location: Morehead City, NC
Distribution: Ubuntu 16.04
Posts: 397

Original Poster
Rep: Reputation: 73
Thanks very much for your response.
 
  


Reply

Tags
mariadb 10, phpmyadmin


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: KDE Participating in Google Summer of Code 2019, MariaDB Releasing New Open-Source MariaDB Enterprise Server, CentOS Celebrates 15th B LXer Syndicated Linux News 0 02-28-2019 06:50 AM
Install LAMP - PHP, Apache, mySQL/MariaDB, PhpMyAdmin tuliovargas Linux Deepin 6 04-28-2017 12:56 AM
phpMyadmin config.inc.php issue v 4.3.3 on mariadb 10.0.14 lost_time Linux - Software 1 12-28-2014 09:55 PM
phpmyadmin shows blank page; no "phpmyadmin" database in mysql qajaq Linux - Software 2 12-20-2009 12:23 PM
Installing Suse on HP laptop, any known issues? feed_sparky Linux - Laptop and Netbook 4 01-15-2007 07:33 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:54 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration