Re: is this normal?
>> >> > Yes you're right! you can safely delete those - but first make some > changes... as it seems you've set up root password only for : > [EMAIL PROTECTED] - right? that's why you can't login using > localhost (mysql without -h host option assumes -h localhost and if you > only changed password for [EMAIL PROTECTED] then password for > [EMAIL PROTECTED] is probably still the same default *no password* :) > In that case to login with password you changed try (I assume mysql > runs without --skip-netowrking) following instead: > mysql -h my.machine.name.xxx -u root -p thanks i already have that. fot both my.machine.xxx and localhost.. logging in as root wasn't the issue. those where the first passwords i did set up. i just freaked out for a minute there realizing that typing -u some-stuff will get you in even if you can't do anything inside. i did try select - not even that... and no, you can't see test - at least not on this sql - 5.0.* thanks again... -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is this normal?
> Sorry I first misread yor question (I hope I cancelled prev. post on time). I thought you have problems connecting to mysql while actual problem is: Why it is so easy for everyone (even from outside) to connect? > Yes this is normal: default user is root *without password* > if you wan't to secure your installation... well just read the manual :-) ok.. but i have root password set up. that works fine. if i'm as root and start the client it complains if i don't indicate that i'll be using password. but if y use _anything-else_ as user (i.e. -u stuff ) it just lets me right through. the users are not real local system users. just invented stuff. once i'm in thought i can not (apparently) do anything - create or drop or anything like that - and don't see any of the databases. but i still shouldn't even get to that point... by default... my guess is that i have to set up a password for '' (empty user) @ localhost and '' (empty user) @ my.machine.name.xxx... right? > http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html > also > http://dev.mysql.com/doc/refman/5.0/en/security.html > HTH > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is this normal?
kalin mintchev wrote: system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i get right in. even if i type -p. i do get the password prompt but doesn't matter what i type there - even nothing i get straight in... is this normal?? thanks... Sorry I first misread yor question (I hope I cancelled prev. post on time). I thought you have problems connecting to mysql while actual problem is: Why it is so easy for everyone (even from outside) to connect? Yes this is normal: default user is root *without password* if you wan't to secure your installation... well just read the manual :-) http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html also http://dev.mysql.com/doc/refman/5.0/en/security.html HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is this normal?
kalin mintchev wrote: system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i get right in. even if i type -p. i do get the password prompt but doesn't matter what i type there - even nothing i get straight in... is this normal?? thanks... What is the error message? Is yor server running? Usually by default this should work: /usr/local/mysql/bin/mysql i.e. default user root without password connecting from localhost or /usr/local/mysql/bin/mysql -u root or (preferably disabled if possible for security reasons if localhost is just enough) /usr/local/mysql/bin/mysql -h host.domain.com -u root -p > after mysql installation and root password set up i can... Well if you also changed some RIGHTS/GRANTs or changing some options in your my.cnf e.g. --skip-networking sometimes lead to this confusion ..or sometimes its just good old Caps Lock :) also look in the manual (depends on your vesrion): http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html HTH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is this normal?
system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i get right in. even if i type -p. i do get the password prompt but doesn't matter what i type there - even nothing i get straight in... is this normal?? thanks... -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Is this normal?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm not sure how cold fusion works with mySQL. I'm not sure if you have to build modules for cold fusion to interface with mySQL, but PHP is built that way. If you upgrade mySQL ( from 3.22 to 3.23 ), you will get these same errors. A rebuild of PHP with the new mySQL development libs solves the problem. Hope this helps. - - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.954.9133 - -Original Message- From: Paul A. Rubin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 8:59 AM To: [EMAIL PROTECTED] Subject: Is this normal? Hello all, I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I have encountered any visible problems, but the error log is full of messages like the following: >010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: >'rubin' host: `localhost' (Got timeout reading communication >packets) Since I'm asleep at 2 a.m. local time, I assume this was generated by someone hitting a Cold Fusion page that queries the database using my id and password. Some of the errors are definitely from Cold Fusion accesses. It's possible they all are, but in many cases I cannot tell. The Cold Fusion server is running on the same Linux box, by the way. Is this normal behavior? TIA, Paul ** * Paul A. RubinPhone:(517) 432-3509 Department of Management Fax: (517) 432- The Eli Broad Graduate School of Management E-mail: [EMAIL PROTECTED] Michigan State University http://www.msu.edu/~rubin/ East Lansing, MI 48824-1122 (USA) ** * Mathematicians are like Frenchmen: whenever you say something to them, they translate it into their own language, and at once it is something entirely different.J. W. v. GOETHE - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com> iQA/AwUBOpPZSLFNxPoD98ryEQJWOQCg1kYwhJIFdlV5mW61f/Djl6POPvUAni/G UY1XnwCzrkFBgcs6VtTvpcwR =LHLK -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is this normal?
Hello all, I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I have encountered any visible problems, but the error log is full of messages like the following: >010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: 'rubin' >host: `localhost' (Got timeout reading communication packets) Since I'm asleep at 2 a.m. local time, I assume this was generated by someone hitting a Cold Fusion page that queries the database using my id and password. Some of the errors are definitely from Cold Fusion accesses. It's possible they all are, but in many cases I cannot tell. The Cold Fusion server is running on the same Linux box, by the way. Is this normal behavior? TIA, Paul *** Paul A. RubinPhone:(517) 432-3509 Department of Management Fax: (517) 432- The Eli Broad Graduate School of Management E-mail: [EMAIL PROTECTED] Michigan State Universityhttp://www.msu.edu/~rubin/ East Lansing, MI 48824-1122 (USA) *** Mathematicians are like Frenchmen: whenever you say something to them, they translate it into their own language, and at once it is something entirely different.J. W. v. GOETHE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is this normal?
Paul A. Rubin writes:
> Hello all,
>
> I'm running MySQL 3.23.32 under Red Hat 7.0. Neither my students nor I
> have encountered any visible problems, but the error log is full of
> messages like the following:
>
> >010221 2:05:06 Aborted connection 1000 to db: 'rubin' user: 'rubin'
> >host: `localhost' (Got timeout reading communication packets)
>
> Since I'm asleep at 2 a.m. local time, I assume this was generated by
> someone hitting a Cold Fusion page that queries the database using my id
> and password. Some of the errors are definitely from Cold Fusion
> accesses. It's possible they all are, but in many cases I cannot
> tell. The Cold Fusion server is running on the same Linux box, by the way.
>
> Is this normal behavior?
>
> TIA,
>
> Paul
>
>
> ***
> Paul A. RubinPhone:(517) 432-3509
> Department of Management Fax: (517) 432-
> The Eli Broad Graduate School of Management E-mail: [EMAIL PROTECTED]
> Michigan State Universityhttp://www.msu.edu/~rubin/
> East Lansing, MI 48824-1122 (USA)
> ***
> Mathematicians are like Frenchmen: whenever you say something to them,
> they translate it into their own language, and at once it is something
> entirely different.J. W. v. GOETHE
>
>
Hi!
That is nothing to worry about.
The above only means that client program has not called mysql_close()
function.
For example, PHP until 4.0.4 (they say) does not do it at all.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
