Failed to connect to database: Access denied for user 'root'@'localhost' (using password: NO) at -e line 6, <> line 1.

[Stéphane]

I'm trying to install bbb-web (0.7ubuntu15). When installing the deb
archive I get this error message:

Failed to connect to database: Access denied for user
'root'@'localhost' (using password: NO) at -e line 6, <> line 1.

Where can I set the mysql root password? If I delete the mysql root
password the install script asks me for the root password twice. If a
enter no password, I get also an error.

Where can I set the root password for installing?

regards

stéphane

[Fred Dixon]

Hi stéphane,

Did you already have mysql installed? Currently, the BigBlueButton
installer will try to create some database tables for a legacy
application in grails (which we are disabling in 0.71).

The default user-name and password bbb-web uses when connecting to
mysql server running on localhost is set in

/var/lib/tomcat6/webapps/bigbluebutton/WEB-INF/classes/bigbluebutton.properties

and is defined in these lines:

dataSource.url=jdbc:mysql://localhost/bigbluebutton_dev
dataSource.username=bbb
dataSource.password=secret
dataSource.driverClassName =com.mysql.jdbc.Driver

Try this.

1. Purge the existing bbb-web.

sudo apt-get purge bbb-web

2. Add the necessary table and users to your mysql database

mysqladmin -u root create bigbluebutton_dev
mysql --user=root -e "grant all on bigbluebutton_dev.* to 'bbb'@'localhost' \
identified by 'secret';flush privileges;" bigbluebutton_dev

3. Then install bbb-web again

sudo apt-get install bbb-web

And let us know if that works.

Regards,... Fred

> --
> You received this message because you are subscribed to the Google Groups "BigBlueButton-Setup" group.
> To post to this group, send email to bigbluebu...@googlegroups.com.
> To unsubscribe from this group, send email to bigbluebutton-s...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/bigbluebutton-setup?hl=en.
>
>

[Stéphane]

Hi Fred,

thanks for the prompt reply. Mysql was running. I have discovered the
file .my.cnf in the home directory of the root user with the mysql
root user and password (so you do not have to enter any credientials,
when running mysql client from root). After removing this file, I
could install bbb-web without any problems.

Regards

Stéphane