enabling remote access my.cnf, stops from pid file

#11

On Jul 9, 2:50*pm, spamb... (AT) milmac (DOT) com (Doug Miller) wrote:

Quote:

In article <8778dc14-8033-4956-a73b-7f6fd0705... (AT) u38g2000prh (DOT) googlegroups..com>, JRough <jlro... (AT) yahoo (DOT) com> wrote:

On Jul 9, 10:19=A0am, Lennart Jonsson <erik.lennart.jons... (AT) gmail (DOT) com
wrote:
On 2010-07-09 19:10, JRough wrote:
[...]

adsl-99-157-73-33:~ jr$ telnet 99.157.73.33 port:3306

This syntax may hold for your version of telnet, but I haven't seen it
before. In the versions of telnet that I have used the syntax would be:

telnet 99.157.73.33 3306

/Lennart

[...]

No it is still UNIX, my mistake, I tried it your way, at least I got a
response message.
it tried for a time and then timed out. so I don't know what the issue
is now.

Probably a router or firewall issue -- something preventing the traffic from
coming through.

Sorry, I thought it was XX.XXX.XXX:3306 I just noticed it is without
the : colon.
I telnet to it again and it does work so it must be only a permissions
issue.
How do I do grant user root @XX.XXX.XXX on database XXXX permission ?

#12

JRough <jlrough (AT) yahoo (DOT) com> wrote:

Quote:

Thanks, made those changes and it started up. It is getting closer.
I can't connect via MySQL Administrator using the root login.
I telneted to the server and this is what I got:
adsl-99-157-73-33:~ jr$ telnet 99.157.73.33 port:3306
99.157.73.33: nodename nor servname provided, or not known

Telnet is not a suitable client to speak to a MySQL server.

Quote:

at least I got a response message. it tried for a time and then timed
out. so I don't know what the issue is now.

Try

shell> mysql -h 99.157.73.33

'mysql' is the name of the MySQL command line client. See also:

http://dev.mysql.com/doc/refman/5.0/en/mysql.html

By default MySQL has a SUPERUSER account root@localhost with no
password. So maybe you better try

shell> mysql -h localhost -u root

This will get you an SQL connection with SUPER privileges.
You are then free to follow

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

XL

#13

On Jul 9, 4:29*pm, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:

Quote:

JRough <jlro... (AT) yahoo (DOT) com> wrote:

Thanks, made those changes and it started up. *It is getting closer.
I can't connect via MySQL Administrator using the root login.
I telneted to the server and this is what I got:
adsl-99-157-73-33:~ jr$ telnet 99.157.73.33 port:3306
99.157.73.33: nodename nor servname provided, or not known

Telnet is not a suitable client to speak to a MySQL server.

at least I got a response message. it tried for a time and then timed
out. so I don't know what the issue is now.

Try

shell> mysql -h 99.157.73.33

'mysql' is the name of the MySQL command line client. See also:

http://dev.mysql.com/doc/refman/5.0/en/mysql.html

By default MySQL has a SUPERUSER account root@localhost with no
password. So maybe you better try

shell> mysql -h localhost -u root

This will get you an SQL connection with SUPER privileges.
You are then free to follow

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

XL

:-(
I logged on with /usr/local/mysql-5.0.77-osx10.4-powerpc/bin/mysql -h
localhost -u root
I get an error message 1045: sh-3.2# /usr/local/mysql-5.0.77-
osx10.4-powerpc/bin/mysql -h localhost -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Why do I get access denied when there is no password required?
thanks,

#14

On Sat, 10 Jul 2010 08:25:46 -0700 (PDT), JRough
<jlrough (AT) yahoo (DOT) com> wrote:

Quote:

On Jul 9, 4:29*pm, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:
JRough <jlro... (AT) yahoo (DOT) com> wrote:

Thanks, made those changes and it started up. *It is getting closer.
I can't connect via MySQL Administrator using the root login.
I telneted to the server and this is what I got:
adsl-99-157-73-33:~ jr$ telnet 99.157.73.33 port:3306
99.157.73.33: nodename nor servname provided, or not known

Telnet is not a suitable client to speak to a MySQL server.

at least I got a response message. it tried for a time and then timed
out. so I don't know what the issue is now.

Try

shell> mysql -h 99.157.73.33

'mysql' is the name of the MySQL command line client. See also:

http://dev.mysql.com/doc/refman/5.0/en/mysql.html

By default MySQL has a SUPERUSER account root@localhost with no
password. So maybe you better try

shell> mysql -h localhost -u root

This will get you an SQL connection with SUPER privileges.
You are then free to follow

http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

XL

:-(
I logged on with /usr/local/mysql-5.0.77-osx10.4-powerpc/bin/mysql -h
localhost -u root
I get an error message 1045: sh-3.2# /usr/local/mysql-5.0.77-
osx10.4-powerpc/bin/mysql -h localhost -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Why do I get access denied when there is no password required?

It just said you wanted to login without supplying a password.
That would work if the mysql root user doesn't have a password
for logins from localhost, but if a password is required, access
will be denied.

Quote:

thanks,

Try:
/usr/local/mysql-5.0.77-osx10.4-powerpc/bin/mysql -h
localhost -u root -p

The -p option tells mysql to prompt for a password and use it for
the login.

See for more details the documentation of the mysql program.
Best regards,
--
( Kees Nuyt
)
c[_]

#15

JRough <jlrough (AT) yahoo (DOT) com> wrote:

Quote:

On Jul 9, 4:29=A0pm, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:

By default MySQL has a SUPERUSER account root@localhost with no
password.

I logged on with /usr/local/mysql-5.0.77-osx10.4-powerpc/bin/mysql -h
localhost -u root
I get an error message 1045: sh-3.2# /usr/local/mysql-5.0.77-
osx10.4-powerpc/bin/mysql -h localhost -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Why do I get access denied when there is no password required?

As I said: this is the default configuration as original MySQL packages
install. Where did you get this MySQL installation package?

Many vendors modify the standard MySQL installation and set passwords
for the initial database accounts. Some even pop up a dialog and ask
you (the one who installs MySQL) for an initial password. Do you
remember anything like that? Have you read the README and stuff that
came with your install package?

If you don't find the initial root password, then you can reset it,
following these instructions:

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

XL

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

enabling remote access my.cnf, stops from pid file

comp.databases.mysql comp.databases.mysql

Re: enabling remote access my.cnf, stops from pid file - 07-09-2010 , 06:13 PM

Re: enabling remote access my.cnf, stops from pid file - 07-09-2010 , 06:29 PM

Re: enabling remote access my.cnf, stops from pid file - 07-10-2010 , 10:25 AM

Re: enabling remote access my.cnf, stops from pid file - 07-10-2010 , 03:22 PM

Re: enabling remote access my.cnf, stops from pid file - 07-12-2010 , 02:00 AM