Fresh Install of Mysql?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kilbey1
Forum Newbie
Posts: 4
Joined: Tue Nov 26, 2002 7:18 pm
Location: Pittsburgh

Fresh Install of Mysql?

Post by kilbey1 »

I am running Apache on Mac OS 10.2.2. I installed phpmyadmin and had it working great!

Now... every time I log into phpmyadmin, it tells me 'wrong username/password, access denied.' So I looked further into things.

I have looked over a variety of help pages on the web, and it lead me to believe that I don't have mysql running. So I tried to get it running using mysqladmin and mysqld. Nothing... can't connect to socket when trying mysqld, and mysqladmin isn't even found (though I see it in my directories).

I've installed and reinstalled mysql. How can I wipe it out and start over fresh?!

Thanks,
Eve
eve71@starband.net
kilbey1
Forum Newbie
Posts: 4
Joined: Tue Nov 26, 2002 7:18 pm
Location: Pittsburgh

Addition...

Post by kilbey1 »

I'll add the 3 problems that occur...

1. Can't connect to '/tmp/mysql.sock' (2)
Check on web, renamed my.cnf file. Now I get:

2. The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/safe_mysqld.

3. Somewhere along the line, I also got:
Can't transfer to '/usr/local/mysql/data', access denied.

NOTHING called mysqld exists on my system.

What's up?
kilbey1
Forum Newbie
Posts: 4
Joined: Tue Nov 26, 2002 7:18 pm
Location: Pittsburgh

More...

Post by kilbey1 »

Following a reinstall, and changing my my.cnf to read in client options:
socket = /usr/local/mysql/tmp/mysql.sock
(since /tmp/mysql.sock doesn't work),
I get:

mysqld --socket=/usr/local/mysql/tmp/mysql.sock
./bin/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 13)
021126 21:58:36 Aborting

021126 21:58:36 ./bin/mysqld: Shutdown Complete


- Eve
Post Reply