Can't connect to database on different port

[reetp]

Hi.

I have a copy of mysql55 on my server and that runs on port 3307. Note that I know there is an obscure bug with PHP that requires you to use 127.0.0.1 instead of localhost when using another port (took me ages to figure this on my CRM system!)

I have setup a prestauser and created a blank DB on the MySQL server.

When I run the install and try to test the connection I get:

Database Server is not found. Please verify the login, password and server fields (DbPDO)

I have forced it to try with MySQLi too by hacking the Db.php file and forcing DbMySQLi but that fails as well.

I've tried setting PS_DEBUG_SQL = true but see no logging anywhere.

I've tried running install_cli.php

php71 ./index_cli.php --step all --db_server 127.0.0.1:3307 --db_name prestashop --db_user prestauser --db_password abc1234

This is the reply:

Quote

Link to database cannot be established: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

Seems that it continually default to using root@localhost and ignoring the CLI arguments and I don't see why?

The CLI settings seem to be totally ignored every time.

Any suggestions appreciated.

[lototo]

Run 

mysql> SHOW GLOBAL VARIABLES LIKE 'PORT';

 

[reetp]

Thanks for the reply...

[root@test Prestashop]# mysql55 -u prestauser -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1363074
Server version: 5.5.52 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW GLOBAL VARIABLES LIKE 'PORT';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3307  |
+---------------+-------+
1 row in set (0.00 sec)

mysql>

 

[root@test Prestashop]# netstat -tulpn |grep 3307
tcp        0      0 0.0.0.0:3307                0.0.0.0:*                   LISTEN      4285/mysqld     

[reetp]

Ahhh - I think user stupidity and a long week got me here....

I think I spelled 'prestashop' as 'prestahop'

Doesn't matter how long you have been doing this, you still miss silly tricks on bad days.....

😥

I''ll correct it and post back.