MySQL permissions

I’m trying to update the “AUTO_INCREMENT” column of the “TABLES” table in the “information_schema” database. I’ve tried connecting to MySQL as user “bitnami” and as the root, and in both cases, I get the following error (different only where it names the user):

ERROR 1044 (42000): Access denied for user ’root’@’localhost’ to database ‘information_schema’

Any thoughts? I would have thought that root would have permission to change all the databases…

Hi,

Do you have installed Redmine on Linux, OS X or Windows? To access to the database is necessary to run the mysql client in the same machine that you installed the Stack. On Windows you should run the mysql command from the “use_redmine” console that you can find in the shortcuts. On Linux and OS X you should run the “use_redmine” script before running the mysql command. For example:

$ cd
$ ./use_redmine
$ mysql -u root -p

Cheers.

Sorry for not giving more info. I need to do the same thing on OS X and Linux. Right now I’m on OS X and here is what the session looks like:

Welcome to Darwin!

reggilm1-ml1:~ reggilm1$ cd /Applications/redmine-0.8.4-1/

reggilm1-ml1:redmine-0.8.4-1 reggilm1$ ./use_redmine

bash-3.2$ mysql -u root -p
Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.0.67 MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> show databases;
-————————-
| Database |
-————————-
| information_schema |
| bitnami_redmine |
| mysql |
| test |
-————————-
4 rows in set (0.00 sec)

mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> update TABLES set AUTO_INCREMENT = 1 where TABLE_NAME = ‘issues’;
ERROR 1044 (42000): Access denied for user ’root’@’localhost’ to database ‘information_schema’

Can you see what I’m doing wrong? Thanks so much.

I think that you should modify the “bitnami_redmine” database, not the “information_schema” database. Try the same commands but using the “bitnami_redmine” database:

mysql> use bitnami_redmine;

Cheers.

I don’t think that will work. I want to update one of the tables in the information_schema database, not in the bitnami_redmine database. So, if I want to update the TABLES table, it would give me the following error:

ERROR 1146 (42S02): Table ‘bitnami_redmine.tables’ doesn’t exist

Another thing. I can’t locate any directory where the information_schema database is stored… It must be somewhere since the tables are there and have data in them. For the “bitnami_redmine”, “mysql” and “test” databases, there are directories in the mysql/data directory named “bitnami_redmine”, “mysql”, and “test” with respective *.frm files for each table in the databases. There is not an equivalent directory for the “information_schema” database. Shouldn’t there be…? Here’s what I have in my mysql/data directory:

bitnami_redmine (directory)
ib_logfile0
ib_logfile1
ibdata1
mysql (directory)
mysqld.log
test (directory)

This seems fishy to me…

Thank you for all your help!

Ah, turns out I was barking up the wrong tree. Here’s some info if anyone ever is looking at the same thing I was… Thanks for the help, anyway!

http://dev.mysql.com/doc/refman/5.0/en/informat…