Moving from 1.10.1 to current - MySQL unable to connect?

[8baller]

Hey all,

I'm just looking to get the current version up on a gcloud instance.

I've mysqldumped and restored, and tgz'd the content into its new home.

# mysql -u 8ball -p 8ball_db
Enter password: <known password>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 77
Server version: 5.5.53-0ubuntu0.14.04.1 (Ubuntu)

mysql> SELECT USER(),CURRENT_USER();
+--------------------------+--------------------------+
| USER() | CURRENT_USER() |
+--------------------------+--------------------------+
| 8ball@localhost | 8ball@localhost |

But visiting http://x.x.x.x/CMSMS/
Gives:
Attempt to connect to database 8ball_db on 8ball@localhost failed'' in /var/www/html/CMSMS/lib/adodb.functions.php on line 89

(NOTE: Username is not 8ball, not does it start with a numeral, it does contain both numbers and _'s though)

So, i'm able to log into the db via command line, but adodb is failing (phpinfo() is happy)

I'd appreciate any debug suggestions.

[8baller]

Solved:

localhost and 127.0.0.1 aren't the same thing.

mysql -P 3306 --host=localhost -u 8ball -p
mysql -P 3306 --host=127.0.0.1 -u 8ball -p

Give different results. Localhost redirects to the local mysql socket, which didn't have permissions in this instance.