Hi.
Thanks for the prompt reply.
It seems strange that the installation procedure should include an
instruction that requires a password with no indication that one is
required (i.e. there is no -p in the command sequence). Reading through
Mark Liyanage's installation instructions, I notice that the second
command ( /usr/local/mysql/bin/mysqladmin -u root -h localhost password
mysql) is not included.
Your recommended instruction to set the password from inside MySQL
(GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword')
worked fine.
My (perceived) problem with the PowerBook is that when at work the
PowerBook is connected to a server via an Ethernet connection - the
server then gives the PowerBook a hostname which is different from that
when I have the PowerBook at home (and not networked): in both
locations `hostname` gives different results. Could I set-up a root
user (or any other user) with the '@%' hostname ?
I would hope to read through the Reference Manual, but at 800 - 1000
pages, I thought I might wait for the video :)
Many thanks,
Cheers,
Alex Brown
MRC-T.
On Wednesday, December 3, 2003, at 09:39 PM, Michael Stassen wrote:
Alex Brown wrote:
Hi.
I installed MySQL on a Mac (OS 10.1) a while ago with the good
intension of learning to use, and using, MySQL, but other things got
in the way. However, I have finally found some time (so far) and I am
now trying to install the latest version of MySQL (4.0.16) onto OSX
10.2 (on an iMAC G4), and I must admit to having run into a problem (
I have a vague recollection of having problems before).
I have a similar setup: 4.0.16 on 10.2.8 on an iMac G3.
I downloaded the installation file mysql-standard-4.0.16.dmg from the
MySQl web site as recommended by Mark Liyanage, and followed the
installation instructions given in the README. All was fine until I
reached the point where the root password is set - the following is
what happened
[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root password
mysql
This set the password for [EMAIL PROTECTED] to "mysql". (I hope that's
not the real password.)
[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h
`hostname` password mysql
/usr/local/mysql/bin/mysqladmin: connect to server at 'blah.local.'
failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
The error says that you are connecting as [EMAIL PROTECTED], but you
didn't supply the password, which is needed because you just set it in
the first step.
[blah:~] alexbrown% /usr/local/mysql/bin/mysqladmin -u root -h
localhost password mysql
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Same here.
The last command I got from the searchable Reference Manual, from a
posting made by briantrino.
Could someone please explain. I must admit that the program is
running, and I have four users, two of whom are 'root', one on
'localhost' with a password and the other on 'blah.local.' with no
password. The other two users have no user-name or password. Can I
set the password for the other 'root' (on 'blah.local.') fromiside
MySQL ? What are the other two unnamed users ?
Yes, you can do this within mysql. Use
mysql -u root -p mysql
to log into mysql as [EMAIL PROTECTED] You'll be prompted for the
password. Use the one you set in step 1. Then enter
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'newpassword'
Replace newpassword with the password you want for [EMAIL PROTECTED]
The two users with empty username and password fields are the
anonymous user, one for localhost, one for external access. If you do
not need them, you can safely delete them. (I'd definitely get rid of
the external anonymous user.)
For more detailed info, see "MySQL User Account Management"
<http://www.mysql.com/doc/en/User_Account_Management.html> in the
manual.
I am hoping to install MySL onto a PowerBook G4. The above problem
may more obvious here as the 'host' can appear to change depending on
whether the PowerBook is on the internet or not.
Note that you don't actually need a [EMAIL PROTECTED] account if you
connect from localhost. You only need a [EMAIL PROTECTED] account if you want
that user to be able to connect from the named external host.
I hope this all make some sense, and that someone can help.
Many thanks in advance,
You're welcome.
Alex Brown
MRC-T.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]