If you did original linux install and included mysql server db in that
install, it likely asked for a "mysql root user" password on install; if
not u shud be able to use mysql command line interface or
MySQLadmin/workbench GUI access to do it.
it is mySQL ROOT PW is looking for i think as I recall NOT the linux
user PW that is logged onto the machine/network nor the RD user / password.
When using RDAdmin first time through it asks for mysql root user (ie db
server admin access) to create the RD DB, then whenever RD runs the RD
user it created and set permissions for on DB creation is what is used
to update database. At that point it would be the RD user and password
that was created in the mysql users table associated with the RD catalog
if u are using mysql admin/workbench gui.
Any user that can log into the linux OS can also be added as a user in
the mysql DB and given whatever permissions you want to control or
access any db in mysql collections using mysql admin/workbench.
Just have to be sure you don't get the users confused.
If you installed RD and specified a default RD user to also be created
in the OS user database, then the RD username will also serve as the
linux OS user. But linux root and mysql root users will still be
different and high level permissions.
On 12-02-07 07:17 PM, Bill Putney wrote:
Is there any of the RRAbuntu development folks around? I haven't seen
Geoff or Frederick on the board for a while.
Has anyone noticed that the System Info button in the RDAdmin screen
still shows Rivendell version 1.7.1? I've loaded what I think is the
most recent version RRAbuntu v1.13.iso. I thought that should be 2.1.2.
Bill Putney - KPTZ Port Townsend, WA
On Tue, Feb 7, 2012 at 11:00 AM, Bill Putney <[email protected]
<mailto:[email protected]>> wrote:
I tried using the only password anyone has suggested for
Rivendell's root MySQL password "mysql" and this is what I get;
root@auto-srv:~/etc# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using password: YES)
On Tue, Feb 7, 2012 at 9:28 AM, Kevin Miller <[email protected]
<mailto:[email protected]>> wrote:
On 02/07/2012 08:18 AM, Bill Putney wrote:
> Can someone help me out with an RRAbuntu MySQL password issue?
>
> When I put "mysql -u root -p mysql"
> The system replies with "PASSWORD:"
>
> Then I'm stuck. I'm trying to replace the hostname localhost
with % on
> the server so the clients can access the sever copy of
MySQL. I've
> already changed the bind address to 0.0.0.0 from 127.0.0.1.
>
> Thanks, Bill Putney - KPTZ Port Townsend, WA
I think what you want to do is just
mysql -u root -p
then enter the password when prompted. YLooking at that
command line,
I'd expect mysql to be interpreting "mysql" as the password you're
trying to pass. If that's the case you shoud probably come up
with a
more secure password. I suspect rather you're trying to pass
the name
of the database to use. If that's the case, after you enter the
password, issue the command
USE mysql;
It's been ages since I played w/mysql so maybe I'm crossing
some wires,
but I think that should get you going...
...Kevin
--
Kevin Miller
Juneau, Alaska
http://www.alaska.net/~atftb <http://www.alaska.net/%7Eatftb>
"In the history of the world, no one has ever washed a rented
car."
- Lawrence Summers
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev