mysql server Mageia 3

This forum is dedicated to basic help and support :

Ask here your questions about basic installation and usage of Mageia. For example you may post here all your questions about getting Mageia isos and installing it, configuring your printer, using your word processor etc.

Try to ask your questions in the right sub-forum with as much details as you can gather. the more precise the question will be, the more likely you are to get a useful answer

mysql server Mageia 3

Postby Shambal » May 30th, '13, 20:38

Greetings, comrades.

I have some problem. Until yesterday I used Ubuntu 12.04. I developed application with Qt and mysql. I created mysql database with Mysql Workbench. I don't like Ubuntu, because it isn't as stable as i want and those orange color makes me angry. Today I decided to try another linux distro and choosed Mageia. Everything was fine until I tried to restore my mysql database. I installed Mysql Workbench, but cannot create connection. After searching in Google i found that mysql was replaced with MariaDB.

Question: what I need to do to restore my mysql database? It's not important for me to use mysql server. If I can use MariaDB in my Qt project (with no changes), I will use it. But don't know how.

Sorry for my english, didn't find russian forum. :) And thanks for help.
Shambal
 
Posts: 2
Joined: Apr 17th, '12, 23:45

Re: mysql server Mageia 3

Postby oldcodger » May 30th, '13, 23:07

Greetings shambal, I use Mariadb which is a dropin replacement for mysql, which means it behaves just as mysql does. I use old databases that were created with Mysql without any problems.
I could never get Workbench to get along with Mandriva or Mageia, so I now use 'phpmyadmin' which is in the repos. As for using the databases with QT, you will need the correct libraries which are also in the repos and rebuild your Qt applications.
I hope I am making things clear for you. I understand your Russian, I just hope you understand mine. :)
oldcodger
 
Posts: 78
Joined: Apr 29th, '11, 10:25
Location: England

Re: mysql server Mageia 3

Postby Shambal » May 30th, '13, 23:32

Thanks, oldcodger. I'll try to do what you said and I'll reply if there will be troubles.
Shambal
 
Posts: 2
Joined: Apr 17th, '12, 23:45

Re: mysql server Mageia 3

Postby djennings » May 31st, '13, 01:49

MariaDB does not have a root password defined when it is first installed, so the first thing you must do is define one.
Also although mariadb is a drop in replacement for mySQL you may need to install the add on package containing deprecated database engines to be compatible with your old installation. I am away from my computer at the moment and cannot remember the name, but if you search for mariadb in the software install GUI you will find it.
User avatar
djennings
 
Posts: 613
Joined: Jun 2nd, '11, 23:51
Location: Wokingham, UK


Return to Basic support

Who is online

Users browsing this forum: No registered users and 1 guest