Connect problem

Connect problem

am 27.04.2006 13:30:24 von mrskinnypete

Hi,

I am having a problem getting into a database. The user who normally
access it just received a new machine and does not remember his
connection info. The database is on a linux box, and I have root
access to it.

I managed to log into the database as *root* and look at the mysql user
table. Two table entries are shown below

mysql> select Host,User from user;
+----------------+--------------+
| Host | User |
+----------------+--------------+
| % | jbasque |
| 192.168.202.73 | jbasque |
| jbasquelx | |
| jbasquelx | NavoSOP_demo |
| jbasquelx | ShoaSOP_demo |
| jbasquelx | root |
| localhost | |
| localhost | jbasque |
| localhost | root |
+----------------+--------------+
9 rows in set (0.00 sec)

I was able to log into mysql with user jbasque from the lincux box, but
can not do it from mysql control center. The user needs to be able to
log in from their desk.

Any help would be much appriciated.

Thanks
Peter