You are not logged in.

#1 2013-04-08 21:15:52

cybertus
Member
Registered: 2013-03-19
Posts: 14

mariadb and phpmyadmin problem

Hi guys, I'm trying to install lampp on archlinux and I have a problem with mariadb and phpmysql, I think.

This is my error, sorry because screenshot is in spanish:

19miqs.png

MySQL said:
#2002 - No such file or directory

The server is not responding (or local MySQL server socket is not correctly configured).

The connection to controluser, as defined in your configuration failed.

and when I start lampp this is the output:

Starting XAMPP for Linux 1.8.1...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Another MySQL daemon is already running.
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

I deleted mysql before install mariadb

EDIT:

dbijgx.png

Last edited by cybertus (2013-04-08 21:50:17)

Offline

#2 2013-04-08 22:47:04

felipense
Member
Registered: 2013-04-05
Posts: 62

Re: mariadb and phpmyadmin problem

Why don't install apache, php, mysql, phpmyadmin instead lampp?

systemctl  status mysqld.service
systemctl  stop mysqld.service

an then start again lamp.

Offline

#3 2013-04-08 23:11:55

cybertus
Member
Registered: 2013-03-19
Posts: 14

Re: mariadb and phpmyadmin problem

Thanks for response. I have installed those packages, except mysql. I read on the wiki that I must delete mysql to get mariadb working.

I executed those instructions, restarted lampp and there's no changes. Now I have MySQL database green on XAMPP status, but I have the same error on phpmyadmin.

Offline

#4 2013-04-08 23:30:40

felipense
Member
Registered: 2013-04-05
Posts: 62

Re: mariadb and phpmyadmin problem

Delete xampp. is not officially suported by archilinux. Install apache, php, mariadb, phpmyadmin following the wiki and everything should work fine. Xampp is for windows enviroments. Phpmyadmin works fine here.(mariadb)

Last edited by felipense (2013-04-08 23:59:22)

Offline

#5 2013-04-09 00:16:54

cybertus
Member
Registered: 2013-03-19
Posts: 14

Re: mariadb and phpmyadmin problem

Thanks again. That doesn't work. This is the steps I followed:

Installing mariadb: https://wiki.archlinux.org/index.php/MariaDB

I installed with pacman: php-apache, apache, php, phpmyadmin (not mysql was installed)

I installed xampp as it says https://wiki.archlinux.org/index.php/Xampp

On XAMPP status i have mysql database deactivated(red) and I cant open phpmyadmin.

EDIT: Ok, I removed xampp, but how i can configure phpmyadmin to works with mariadb?

Last edited by cybertus (2013-04-09 00:18:57)

Offline

#6 2013-04-09 04:07:02

T.J.S.
Member
Registered: 2012-08-14
Posts: 83

Re: mariadb and phpmyadmin problem

Before you configure phpmyadmin, you have to enable php by following these instructions.
You also need to configure mariadb, as described in the same page.

After doing those steps, you can configure phpmyadmin by following the instructions in the respective wiki page. (link)

Offline

#7 2013-04-09 16:34:57

cybertus
Member
Registered: 2013-03-19
Posts: 14

Re: mariadb and phpmyadmin problem

I followed these instructions a few days ago. I don't know if I did something wrong or I skipped some step, but phpmyadmin doesnt want to work with mariadb sad anyway, i will try again reinstalling all the packages. let me some days to do it. I'm pretty sure that there would be some place where i must say to phpmyadmin to work with mariadb and no with mysql and these instructions https://wiki.archlinux.org/index.php/LAMP#MariaDB doesn't work for me. I've even executed create_tables.sql on examples folder from phpmyadmin

Offline

#8 2013-04-09 17:42:50

T.J.S.
Member
Registered: 2012-08-14
Posts: 83

Re: mariadb and phpmyadmin problem

Ok, this might be obvious, but do you start mysql ? Like

# systemctl start mysqld.service

edit. this has already been posted in the thread, so it's not that.
You might have some leftover files from mysql which mess with phpmyadmin. Did you follow the instructions in the main page about migrating to mariadb?


You don't have to "say" something to phpmyadmin btw, I got the whole thing working a few days ago, by simply following the wiki.

Last edited by T.J.S. (2013-04-09 17:58:18)

Offline

#9 2013-04-09 21:38:01

cybertus
Member
Registered: 2013-03-19
Posts: 14

Re: mariadb and phpmyadmin problem

Ok, I got it working. I don't know exactly what I did because I uninstalled mariadb, I installed mysql to try with it, then I installed mariadb again... I execute # systemctl start mysqld.service again, I modified config.inc.php file to add $cfg['Servers'][$i]['host'] = '127.0.0.1'; as I did before... and now its working. Thanks all for your suggestions!

Last edited by cybertus (2013-04-09 21:48:57)

Offline

Board footer

Powered by FluxBB