mysql | mariadb how to

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 | mariadb how to

Postby Spinnifex » Mar 25th, '20, 13:51

Hello

I have questions about mysql|mariadb.
I want to use mysql|mariadb for local user projects.
I am familiar with mysql and mariadb is a so called drop in replacement.
So how can I connect as a unprivileged user to a mariadb server.
Say I want to connect to localhost and create a new scheme.
I want to use mysql-workbench if possible. If not is there an alternative to this GUI tool?

best regards and best health

Spinnifex
Spinnifex
 
Posts: 123
Joined: Nov 25th, '19, 12:38
Location: Europe / Potsdam

Re: mysql | mariadb how to

Postby bitit » Mar 26th, '20, 14:34

bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01

Re: mysql | mariadb how to

Postby Spinnifex » Apr 11th, '20, 16:22

Hello

bitit wrote:have you try secure installation?

https://mariadb.com/kb/it/mysql_secure_installation/


No because I have no trouble to communicate with mysql as admin.
But I can not work as a local user with it.
I created a privileged user with my admin account.

Unfortunately I was not able to use this account with a IDE like eclipse or netbeans.
On terminal I can connect. But not with those IDE's.
I installed
Code: Select all
mysql-workbench

But there I can again get no connection with this account.
I grant all privileges to this local account.

Anyone have ideas?

Thank you for the link anyway. :-)

best regards
Spinnifex
Spinnifex
 
Posts: 123
Joined: Nov 25th, '19, 12:38
Location: Europe / Potsdam

Re: mysql | mariadb how to

Postby bitit » Apr 11th, '20, 17:06

i also have problems with mysql-workbench, i not able to connect it to mariadb, seem a problem of the software , i have readed to upgrading to latest version, but haven't tried.

have you try to simulate a remote connection whit ip 127.0.0.1 ?

Enrico
bitit
 
Posts: 162
Joined: Feb 3rd, '16, 14:01


Return to Basic support

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron