1

Topic: Problems with connection of the user to MariaDB distinct from root

I use XAMP for local development. In the last versions in it it is used MariaDB. Probably it somehow is connected to a problem of connection of the user. The matter is that I can be connected to a DB only as root and if I create  with the specific password, in any way. In what here there can be a business?

2

Re: Problems with connection of the user to MariaDB distinct from root

rema174 wrote:

if I create  with the specific password, in any way. In what here there can be a business?

And the rights to a connection from the necessary host of a distance?

3

Re: Problems with connection of the user to MariaDB distinct from root

miksoft wrote:

it is passed...
And the rights to a connection from the necessary host of a distance?

What means? I specify localhost in adjustments .

4

Re: Problems with connection of the user to MariaDB distinct from root

rema174;
By the way,  for basis I create in phpMyAdmin

5

Re: Problems with connection of the user to MariaDB distinct from root

rema174 wrote:

it is passed...
What means? I specify localhost in adjustments .

Is not present, there is to a type a host specified at creation of the user.
https://dev.mysql.com/doc/refman/5.7/en … names.html

6

Re: Problems with connection of the user to MariaDB distinct from root

miksoft;
Here an error

wrote:

CakePHP is NOT able to connect to the database. Connection to database could not be established: SQLSTATE [HY000] [1045] Access denied for user ' cakephp ' ' localhost ' (using password: YES)

It turns out  knows, what host to substitute,
And at   in a DB it has been specified % , . is any host

7

Re: Problems with connection of the user to MariaDB distinct from root

% - It is any host except localhost

8

Re: Problems with connection of the user to MariaDB distinct from root

retvizan;
Thanks, work now