Remote connection

------_=_NextPart_001_01CA153F.6FEE3C22
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello Guys,

=20

I have a big doubt.

=20

I'm trying to access the mysql database remotely, but I can't.

=20

I have changed the skip-networking option on my.cnf file however it
doesn't work.=20

=20

I have tried to include the bind_address =3D 0.0.0.0 but it still =
doesn't
work. Sure I have commented the skip-networking option before enable the
bind_address.

=20

I don't know what else I must do. Please, anybody can help me ?

=20

Look at the error message below.

=20

# mysql -u root -p -h 192.168.12.50

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using
password: YES)

=20

Cheers,

Hugo

=20

=20


------_=_NextPart_001_01CA153F.6FEE3C22--

RE: Remote connection

May not have root access to remotely!
Try to reconfigure the parameters of the engine.

although it is not good idea to allow remote access to the root user!.

Greetings,
Pablo

-----Mensaje original-----
De: Hugo Leonardo Ferrer Rebello [mailto:Hugo.Rebello@t-systems.com.br]
Enviado el: Martes, 04 de Agosto de 2009 05:09 p.m.
Para: mysql@lists.mysql.com
Asunto: Remote connection

Hello Guys,



I have a big doubt.



I'm trying to access the mysql database remotely, but I can't.



I have changed the skip-networking option on my.cnf file however it
doesn't work.



I have tried to include the bind_address = 0.0.0.0 but it still doesn't
work. Sure I have commented the skip-networking option before enable the
bind_address.



I don't know what else I must do. Please, anybody can help me ?



Look at the error message below.



# mysql -u root -p -h 192.168.12.50

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using
password: YES)



Cheers,

Hugo







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Remote connection

Are you sure that root has granted access to connect remotely ??

Carlos

On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote:
> Hello Guys,
>
>
>
> I have a big doubt.
>
>
>
> I'm trying to access the mysql database remotely, but I can't.
>
>
>
> I have changed the skip-networking option on my.cnf file however it
> doesn't work.
>
>
>
> I have tried to include the bind_address = 0.0.0.0 but it still doesn't
> work. Sure I have commented the skip-networking option before enable the
> bind_address.
>
>
>
> I don't know what else I must do. Please, anybody can help me ?
>
>
>
> Look at the error message below.
>
>
>
> # mysql -u root -p -h 192.168.12.50
>
> Enter password:
>
> ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using
> password: YES)
>
>
>
> Cheers,
>
> Hugo
>
>
>
>
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Remote connection

1.) remove bind-address=3D and skip-networking from my.cnf
2.) grant permission to the external 'user'@'host'
3.) remove any firewall rules blocking port 3306
4.) make sure no overrides on the mysqld commandline.

See http://hashmysql.org/index.php?title=3DRemote_Clients_Cannot _Connect


If you continue to have problems, give us the exact steps you have tried an=
d the exact error message you are receiving. Please try to connect using t=
he mysql command line.

Regards,
Gavin Towey

-----Original Message-----
From: Hugo Leonardo Ferrer Rebello [mailto:Hugo.Rebello@t-systems.com.br]
Sent: Tuesday, August 04, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Remote connection

Hello Guys,



I have a big doubt.



I'm trying to access the mysql database remotely, but I can't.



I have changed the skip-networking option on my.cnf file however it
doesn't work.



I have tried to include the bind_address =3D 0.0.0.0 but it still doesn't
work. Sure I have commented the skip-networking option before enable the
bind_address.



I don't know what else I must do. Please, anybody can help me ?



Look at the error message below.



# mysql -u root -p -h 192.168.12.50

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using
password: YES)



Cheers,

Hugo






The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RES: [SPAM] RE: Remote connection

It=B4s working.

The problem was related to grant permission.

Thank you.

Cheers,
Hugo



-----Mensagem original-----
De: Gavin Towey [mailto:gtowey@ffn.com]=20
Enviada em: ter=E7a-feira, 4 de agosto de 2009 19:46
Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com
Assunto: [SPAM] RE: Remote connection



1.) remove bind-address=3D and skip-networking from my.cnf
2.) grant permission to the external 'user'@'host'
3.) remove any firewall rules blocking port 3306
4.) make sure no overrides on the mysqld commandline.

See =
http://hashmysql.org/index.php?title=3DRemote_Clients_Cannot _Connect


If you continue to have problems, give us the exact steps you have tried =
and the exact error message you are receiving. Please try to connect =
using the mysql command line.

Regards,
Gavin Towey

-----Original Message-----
From: Hugo Leonardo Ferrer Rebello =
[mailto:Hugo.Rebello@t-systems.com.br]
Sent: Tuesday, August 04, 2009 1:09 PM
To: mysql@lists.mysql.com
Subject: Remote connection

Hello Guys,



I have a big doubt.



I'm trying to access the mysql database remotely, but I can't.



I have changed the skip-networking option on my.cnf file however it
doesn't work.



I have tried to include the bind_address =3D 0.0.0.0 but it still =
doesn't
work. Sure I have commented the skip-networking option before enable the
bind_address.



I don't know what else I must do. Please, anybody can help me ?



Look at the error message below.



# mysql -u root -p -h 192.168.12.50

Enter password:

ERROR 1045 (28000): Access denied for user 'root'@'192.168.12.50' (using
password: YES)



Cheers,

Hugo






The information contained in this transmission may contain privileged =
and confidential information. It is intended only for the use of the =
person(s) named above. If you are not the intended recipient, you are =
hereby notified that any review, dissemination, distribution or =
duplication of this communication is strictly prohibited. If you are not =
the intended recipient, please contact the sender by reply email and =
destroy all copies of the original message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

The Execute from the command line

--=_alternative 007525DD85257643_=
Content-Type: text/plain; charset="US-ASCII"

I am using


linuxmachine:/var/wwwdev/lucas# mysql -udatabase -ppassword -e "LOAD DATA
LOCAL INFILE '/var/wwwdev/lucas/cardreaderimport/update.csv' into table
Project.testtest fields terminated by ',' lines terminated by '\n'
(Id,LastName,MiddleName,FirstName,TimeStamp,Ext,Status,Locat ion,Expire,BadgeNum);"

and it works great, I just get no verification that anything has been
loaded in.. if I login it gives me back a little message saying it was
completed and how many are duplicated. How can I get this information from
the command line?

Wishing you the best you know you deserve,

--=_alternative 007525DD85257643_=--

RE: The Execute from the command line

Mysql -vv

See mysql --help for more info

Regards,
Gavin Towey


-----Original Message-----
From: Lucas.CTR.Heuman@faa.gov [mailto:Lucas.CTR.Heuman@faa.gov]
Sent: Friday, October 02, 2009 2:20 PM
To: mysql@lists.mysql.com
Subject: The Execute from the command line

I am using


linuxmachine:/var/wwwdev/lucas# mysql -udatabase -ppassword -e "LOAD DATA
LOCAL INFILE '/var/wwwdev/lucas/cardreaderimport/update.csv' into table
Project.testtest fields terminated by ',' lines terminated by '\n'
(Id,LastName,MiddleName,FirstName,TimeStamp,Ext,Status,Locat ion,Expire,Badg=
eNum);"

and it works great, I just get no verification that anything has been
loaded in.. if I login it gives me back a little message saying it was
completed and how many are duplicated. How can I get this information from
the command line?

Wishing you the best you know you deserve,

The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: The Execute from the command line

--=_alternative 004BCB2D85257646_=
Content-Type: text/plain; charset="US-ASCII"

Thanks that worked.

I was trying -v from the help.





Gavin Towey
10/02/2009 05:30 PM

To
Lucas CTR Heuman/ACT/CNTR/FAA@FAA, "mysql@lists.mysql.com"

cc

Subject
RE: The Execute from the command line






Mysql -vv

See mysql --help for more info

Regards,
Gavin Towey


-----Original Message-----
From: Lucas.CTR.Heuman@faa.gov [mailto:Lucas.CTR.Heuman@faa.gov]
Sent: Friday, October 02, 2009 2:20 PM
To: mysql@lists.mysql.com
Subject: The Execute from the command line

I am using


linuxmachine:/var/wwwdev/lucas# mysql -udatabase -ppassword -e "LOAD DATA
LOCAL INFILE '/var/wwwdev/lucas/cardreaderimport/update.csv' into table
Project.testtest fields terminated by ',' lines terminated by '\n'
(Id,LastName,MiddleName,FirstName,TimeStamp,Ext,Status,Locat ion,Expire,BadgeNum);"

and it works great, I just get no verification that anything has been
loaded in.. if I login it gives me back a little message saying it was
completed and how many are duplicated. How can I get this information from
the command line?

Wishing you the best you know you deserve,

The information contained in this transmission may contain privileged and
confidential information. It is intended only for the use of the person(s)
named above. If you are not the intended recipient, you are hereby
notified that any review, dissemination, distribution or duplication of
this communication is strictly prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies
of the original message.


--=_alternative 004BCB2D85257646_=--