Mageia forum

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

have you try secure installation?

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

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

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