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]
