MySQLdb Unknown MySQL server host

Question

I have python 2.7 installed. I have wamp running. I have MySQL running on 10127 port. I have root set up with no password i have (unrelated) php code running that connects fine with the call mysql_connect('localhost:10127', 'root', '');

when i try from the command line:

mysql -u 'root' -p '' -h 'localhost:10127'

i get the error

Unknown MySQL server host 'localhost:10127'

Similarly, when i make the call

   import MySQLdb as mdb
    import sys
    con = mdb.connect('localhost:10127', 'root','', 'dbname')

i get the error

Unknown MySQL server host 'localhost:10127' (11004)"

Does anyone know why-oh-why?

the MySQLdb problem was fixed by calling MySQLdb.connect(port=10127) — arhud, Nov 16 '11 at 02:57

score 2 · Accepted Answer · answered Nov 16 '11 at 02:26

2

The CLI expects:

mysql -u root -h localhost --port 10127

answered Nov 16 '11 at 02:26

Fluff

548
4
8

score 0 · Answer 2 · answered Nov 16 '11 at 02:25

0

mysql -u 'root' -p '' -h localhost -p 10127

https://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html

answered Nov 16 '11 at 02:25

Dmitry B.

9,107
3
43
64

mysql -u 'root' -P '' -h localhost -p10127 – Sethish Dec 15 '17 at 21:37

MySQLdb Unknown MySQL server host

2 Answers2