Fresh install, admin login for ProxySQL doesn't work.

[Geoff Winans]

So, the docs fairly clearly imply, I should simply install proxysql, start it and should be able to login with the admin:admin credentials.

The result of that attempt is, invariably:

[root@vm-01 ~]# mysql -u admin -padmin -h 127.0.0.1 -P 6032
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

I've gone so far as to issue the initial command as well, no change.

Credentials are in the proxysql.db file..

sqlite> select * from global_variables where variable_value like '%admin%';
admin-admin_credentials|admin:admin

What painfully obvious thing am I missing here?

[René Cannaò]

Hi Geoff,

In case of incorrect credentials on Admin, ProxySQL will reply something like this:

ERROR 1045 (28000): ProxySQL Error: Access denied for user 'admin'@'' (using password: YES)

The error you have is different, therefore shouldn't be coming from ProxySQL.

This seems an error coming from MySQL, not from ProxySQL.

You can verify this by running tcpdump and checking traffic on localhost.

Can you try to add --protocol=tcp in your mysql command line?

Thanks,

René

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Geoff Winans]

That did it! Guess it's defaulting to the socket in spite of the host / port.

[René Cannaò]

Good to hear!

The fact is, it should use tcp if you specify -h .

Can you please share which Linux flavor are you running exactly, and which mysql client version are you using?

This is potentially a bug from the package maintainer.

Thanks

[Geoff Winans]

mysql  Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)

CentOS Linux release 7.5.1804 (Core)

[René Cannaò]

Thank you, we will try to reproduce it.

[Geoff Winans]

In case this helps -- the mysql config (3 node group replica)

----

[mysqld]
datadir = /var/lib/mysql
socket  = /var/lib/mysql/mysql.sock

default-authentication-plugin=mysql_native_password

symbolic-links                   = 0

innodb_file_per_table            = 1
innodb_buffer_pool_size          = 1G

server_id = 1

server_id=1
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE

master_info_repository           = TABLE
relay_log_info_repository        = TABLE
transaction_write_set_extraction = XXHASH64

plugin_load_add = "group_replication.so"

loose-group_replication_bootstrap_group = OFF
loose-group_replication_start_on_boot = ON
loose-group_replication_group_name = 'e1c1beee-b0aa-11e8-b3df-408d5cf09fce'
loose-group_replication_local_address = '192.168.1.10:33061'
loose-group_replication_group_seeds = '192.168.1.10:33061,192.168.1.25:33061,192.168.1.26:33061'

log-error = /var/log/mysqld.log
pid-file  = /var/run/mysqld/mysqld.pid

----

[aaron....@cbsinteractive.com]

I'm running into the same issue on a fresh install to an AWS Linux OS even with the --protocol=tcp option.  I've tried forcing a reload of the config file with no success. 

My error is slightly different

[root@ip-10-23-178-121 ~]# mysql -u bob -h 0.0.0.0 -P 6032 --protocol=tcp -padmin

mysql: [Warning] Using a password on the command line interface can be insecure.

ERROR 1045 (28000): ProxySQL Error: Access denied for user 'bob'@'' (using password: NO)

This is the repo I used for the install:

[root@ip-10-23-178-121 yum.repos.d]# cat proxysql.repo

[proxysql_repo]

name= ProxySQL YUM repository

baseurl=http://repo.proxysql.com/ProxySQL/proxysql-1.4.x/centos/7

gpgcheck=1

gpgkey=http://repo.proxysql.com/ProxySQL/repo_pub_key

[aaron....@cbsinteractive.com]

And yes I did change the user name to bob in the config to try and see if it had something related to admin.

[René Cannaò]

Aaron,

Try to specify --default-auth=mysql_native_password as an option in mysql cli.
 

[Aaron]

Hi Rene,

Thanks for the response.  I reinstalled on a fresh machine as used the mysql client instead of the mysql shell tool and that seems to have solved my issue.  I tried replicating the issue with the mysql shell tool and it still presents the problem and the default_auth switch is not an option with mysqlsh.  

Regards,

Aaron Ballard

[Will Fong]

Hi Rene,

Thanks! Adding the default-auth option worked for me when I using MySQL 8.0 mysql command line client.

-w