Installing and Configuring MySQL

[awpadmin]

System: MAC 10.3.2 G4 workstation

For the past three weeks I am trying to do the "simple" install. But of course it never works the way it reads. I have followed the FAQ and install descriptions that came with the package <

http://www.mysql.com/doc/en/Mac_OS_X_installation.html>

but i am stuck. At the moment I need to create a database and set the root password. i have no idea why it is not working. the following is the command line and error I am getting. Can someone please help me to install this properly? Thanks.

-=awpadmin=-

==========>

/usr/local/mysql/bin/mysqladmin -u root password "newpwd"
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

 

[NorthStarDA]

Have you stopped the built-in mysql before installing the new one? Can you log into the server at all using "mysql -u root"? I assume that you have already run the MySQLStartupItem.pkg, right? It looks like the mysql server has not started, can you verify by using "ps -ax | egrep -i mysql"?

 

[awpadmin]

When I use 'mysqladmin shutdown' I get 'mysqladmin" command not found'. I have installed the MySQLStartupItem.pkg. 'ps -ax | egrep -i mysql' returns:
#:/etc/httpd root# ps -ax | egrep -i mysql
355 ?? S 0:00.03 sh ./bin/safe_mysqld --defaults-file=/Applications/La
386 ?? S 0:00.60 /Applications/LassoProfessional6/LassoMySQL/libexec/ 907 std R+ 0:00.00 egrep -i mysql

 

[NorthStarDA]

hmm, looks like your installed version of MySQL is not running, but the copy that was installed with Lasso Professional is, are you using that copy of MySQL that came with Lasso? I stopped using Lasso a long time ago but I think that it(lasso mysql) runs over the same port as a standard MySQL installation and would need to be turned off before installing a new copy of MySQL, or your new installation should be configured to run on a different port than 3306. I would refer to this page:

http://www.mysql.com/documentation/...Database_Administration.html#Multiple_servers

for information on how to install 2 mysql servers at once.

 

[awpadmin]

Thanks a lot for your input. I dont get paid to mess with this! I am going to consult with the people who setup Lasso on this server.

-=awpafmin=-