i installed MySQL from the Tenon site into OS X pb with the installer.app.
then i did the following:
[doria:~] root# cd /usr/local/mysql
[doria:/usr/local/mysql] root# scripts/mysql_install_db
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
./bin/mysqladmin -u root -p password 'new-password'
./bin/mysqladmin -u root -h doria -p password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
Please report any problems with the ./bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
[doria:/usr/local/mysql] root# ./bin/mysqladmin -u root -p password i8444
Enter password:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
[doria:/usr/local/mysql] root# ./bin/mysqladmin -u root -p password i8444
Enter password:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
[doria:/usr/local/mysql] root# ./bin/mysqladmin -u root -p password i8444
Enter password:
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
[doria:/usr/local/mysql] root# ./bin/mysqladmin -u root -p password 12345
Enter password: 12345
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'
[doria:/usr/local/mysql] root# bin/mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[doria:/usr/local/mysql] root# bin/safe_mysqld &
[1] 323
[doria:/usr/local/mysql] root# Starting mysqld daemon with databases from a
010211 02:58:47 mysqld ended\n
'return'
[1] Done bin/safe_mysqld
[doria:/usr/local/mysql] root# bin/mysql
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql)
[doria:/usr/local/mysql] root#
my friend modified the MySQL startup file to read:
#!/bin/sh
##
# Start MySQL Server
##
. /etc/rc.common
ConsoleMessage "Starting MySQL Daemon"
if [ -x /usr/local/mysql/bin/mysqld ]; then
cd /usr/local/mysql/bin
./mysqld --user=mysql --socket=/tmp/mysql.sock
--datadir=/usr/local/mysql/data
--pid-file=/usr/local/mysql/data/mysql.pid &
fi
this worked great on another Mac. the next day i upgraded both my
home Mac and the other one with all new files from Tenon's site -the
other machine (iMac at work) kept working just great -i'm already
making databases! while my home has worked at one time now all i get
is the above denial of access.
PLEASE HELP once and for all!
Ted
---------------------------------------------------------------------
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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php