Re: MySQL permission
From: Dave Uhring (daveuhring_at_yahoo.com)
Date: 05/26/05
- Next message: SINNER: "Re: Sick of trolls!"
- Previous message: bahhab_at_hotmail.com: "Re: locate - Permission denied"
- In reply to: Timothy Murphy: "Re: MySQL permission"
- Next in thread: Timothy Murphy: "Re: MySQL permission"
- Reply: Timothy Murphy: "Re: MySQL permission"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 26 May 2005 07:31:01 -0500
On Thu, 26 May 2005 12:39:39 +0100, Timothy Murphy wrote:
> Dave Uhring wrote:
>
>> If you had bothered to read and implement the instructions presented to
>> you after installing the initial database you would not have this problem.
>>
>> echo "PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !"
>> echo "This is done with:"
>> echo "$bindir/mysqladmin -u root password 'new-password'"
>> echo "$bindir/mysqladmin -u root -h $hostname password 'new-password'"
>> echo "See the manual for more instructions."
>
> I don't recall getting any such message on my system (Fedora-3).
> What exactly do you mean by "installing the initial database"?
> I just gave the command "sudo yum install mysql-server".
It is generally necessary to execute mysql_install_db; perhaps your distro
has already done that. It certainly was necessary when I set up a
Slackware server using a locally compiled rpm from RHES-3, also on OpenBSD
and Solaris servers.
> However, I have set a password for root
> on my MySQL server (alfred), and have not had any problems on that score.
>
> On the other hand, I have had problems setting a password for root
> on the machine (martha) which I am using to access the server.
>
> I take it the second mysqladmin above is intended for this purpose?
> [It seems to me incidentally that there should be some explanation
> if two different commands are given.
> Are they meant to be alternatives?
> Do you consider that to be obvious?]
Mysql sees localhost as different from $hostname, hence the -h argument.
Yes, it's obvious.
> mysql> grant all privileges on *.* to tim@martha.murphy.ie
> identified by 'tim';
> Query OK, 0 rows affected (0.00 sec)
> Am I right in thinking that this will give user tim
> on the client machine access to everything on the server?
It should. I have not granted all privileges to *.* to remote users,
only to their own databases.
- Next message: SINNER: "Re: Sick of trolls!"
- Previous message: bahhab_at_hotmail.com: "Re: locate - Permission denied"
- In reply to: Timothy Murphy: "Re: MySQL permission"
- Next in thread: Timothy Murphy: "Re: MySQL permission"
- Reply: Timothy Murphy: "Re: MySQL permission"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
