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

Reply via email to