My SQL problem (user privileges)

L

Luiso

Registered
I Installed mySQL on a G5 10.2.8

I followed instructions from Mysql.com on how to install an also went through the manual at php.com. I've really follow the instructions but still I'm getting errors like this

[Max-Canovacas-Computer:/usr/local/mysql] maxcanovaca% shell> mysql -u root test
mysql: Permission denied.

also when I try to set the password...

[Max-Canovacas-Computer:/usr/local/mysql] maxcanovaca% mysql> SET PASSWORD FOR maxcanovaca@localhost=PASSWORD 'wlitho'
SET: Permission denied.

Even when I try to manipulate the privilege table with:

[Max-Canovacas-Computer:/usr/local/mysql] maxcanovaca% shell> mysql -u root mysql
mysql: Permission denied.

I'd please like some help or advice, I don't know if is a Mac OS problem or what?!

I appreciate you help and patience!

Louis M
 
Luiso said:
I Installed mySQL on a G5 10.2.8

I followed instructions from Mysql.com on how to install an also went through the manual at php.com. I've really follow the instructions but still I'm getting errors like this

[Max-Canovacas-Computer:/usr/local/mysql] maxcanovaca% shell> mysql -u root test
mysql: Permission denied.

also when I try to set the password...

[Max-Canovacas-Computer:/usr/local/mysql] maxcanovaca% mysql> SET PASSWORD FOR maxcanovaca@localhost=PASSWORD 'wlitho'
SET: Permission denied.

Even when I try to manipulate the privilege table with:

[Max-Canovacas-Computer:/usr/local/mysql] maxcanovaca% shell> mysql -u root mysql
mysql: Permission denied.

I'd please like some help or advice, I don't know if is a Mac OS problem or what?!

I appreciate you help and patience!

Louis M
Click to expand...

Hi Louis!

First up, try this: /usr/local/mysql/bin/mysqladmin -u root password new_password_here

This will set up a valid default user with regular permissions.

But with this particular install, I don't know if that will work.

This might seem a little late, but you should have gone here first.

This site offers the packages you need to get MySQL installed and running on you mac.

To be honest, getting a bad MySQL install off your system is going something a Unix nerd is going to have to help you with -- which I'm not, I might add!.

Consider me post-catastrophe trauma support.

Hope that helps?..
 
This is what happened:

/usr/local/mysql/bin/mysqladmin -u root password wlitho
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

What I'm going to do is un-install MySQL (following instructions on the entropy page) and the re-install it. I think that something went wrong from the beggining, anyway thanks for your help. There's no Unix nerd around here so I'll guess I'll pray that I don't screw up!
 
Luiso said:
This is what happened:

/usr/local/mysql/bin/mysqladmin -u root password wlitho
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

What I'm going to do is un-install MySQL (following instructions on the entropy page) and the re-install it. I think that something went wrong from the beggining, anyway thanks for your help. There's no Unix nerd around here so I'll guess I'll pray that I don't screw up!
Click to expand...

Well, the problem is, the install that you've used isn't the same as the one from the Entropy site, so the chances are, the un-install procedure isn't the same, either. You could have files in places were the Entropy un-install doesn't know to look.

Best thing to do is go to their support forums and have a look around. See if there's someone else in their with the same problem. If not, register with them and post your problem...
 
Yes, I went to a lot of forums and I'm not alone, I'll delete it and install it again (I have to look for a bunch of files and delete them. Carefully of course.

Then I'll install it again in baby mongoloid steps.

Thanks again
 
Hey mdnky question for you:

This package at "server logistics" it's the same @ Entropy's Mark Liyanage page?

Have u tested it? 'cause looks simple and giving the fact that I'm a newbie on MySQL it could make things easier.

I'm running on OSX 10.2.8 G5
 
Not sure if it's the same or not. I've used their packages before with great suscess, but on 10.1.

It's basically like installing any mainstream app like Photoshop. Once you unzip/tar the download file, just double click on the package and it installs.

You still have to setup the user permissions, but that's an easy task.
 
I know the apache 2.0 from server logistics is installed separate from the one that came with OS X. So, I would guess that mysql is installed the same way.

I managed to install apache 2.0.48, mysql 4.0.15, and php 4.3.4 onto my computer and recreate a php guestbook using flash.
 
You must log in or register to reply here.
Back
Top