Configurar MySQL Administrator?

[koitoer]

Ok, finally I have a solution, maybe a partial solutions but it works.


My system is debian-etch 4.0
My database is Mysql-server mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
And I`m using the Mysql Administrator 5.0 r14
Ok firts when i tried to connected with the db at port 3306 i have the error, that the server doesn`t exist, I think is the error 2003, to correct this error you need to change in the

/etc/mysql/my.cnf a line like this
bind-address = localhost to
bind-address = 0.0.0.0

to give the access of all your interfaces and ip addresses, I think with that configuration works, but I was in a mistake, when I tried to connect now I have the 1045 error XD, but few minutes later I have the answer for that problem


First this happend because when you have your table mysql.user yo have a column called host, in this column you have the permited host that you can connect. How you can see, im only have access for the account root when I´m in localhost

mysql> select Host,User,Password from mysql.user;
+----------------+------------------+-------------------------------------------+
| Host | User | Password |
+----------------+------------------+-------------------------------------------+
| localhost | root | *F8F7C02098CB2392CB717B9C288A37C0C853990E |


Ok to correct this error, I copy this account and only change de value in the Host column, and then

mysql> select Host,User,Password from mysql.user;
+----------------+------------------+-------------------------------------------+
| Host | User | Password |
+----------------+------------------+-------------------------------------------+
| localhost | root | *F8F7C02098CB2392CB717B9C288A37C0C853990E |
| 132.248.214.72 | root | *F8F7C02098CB2392CB717B9C288A37C0C853990E |

update mysql.user set Password=PASSWORD('my_passwd') where User="root" and Host="132.248.214.72";

viola, I have access for root outside the localhost, and now i can connect with mysql administrator for windows XDXDXD

I hope this information will be usefull for people who have the 1045 and 2003 error.


Koitoer