Topic: MySQL and root user privileges

[d_loayza]

A few months ago I had problems with MySQL, I found a corrupt InnoDB database and    the service MySQL was down, I fixed it, but in the process the root user lost your  privileges. When the SME server starts the initial MySQL scripts don´t work indicating the error "access denied for root".

The sad thing that so far the server is running smoothly, I can create users, ibays, manage, fetchmail, sarg, etc.

I need install FreePBX, but this problem prevents me from install.

I have a lot of information on the server and do a clean install would take me a long time I wanted to avoid. I've followed the tutorials to reset passwords, etc. is not a problem of "password", because can enter the MySQL console, is a problem of privilege.

Someone can help this disgraced engineer? 

Thanks in advance.

Daniel Loayza

[janet]

d_loayza

Did you do this (for sme7.3)
http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password
and this
http://wiki.contribs.org/MySQL#Restoring_accidently_deleted_MySQL_root_user

[CharlieBrady]

The sad thing that so far the server is running smoothly, I can create users, ibays, manage, fetchmail, sarg, etc.

mysql in base SME server is only used to store webmail user preferences.

[d_loayza]

Mary and CharlieBrady.

The root user exists in MySQL, what happens is they lost their privileges. I tried to delete the root user, but since he has no privileges in MySQL will not let me delete it.

How I can delete the root user?

Thanks in advance.

[d_loayza]

The root user has no access to the mysql database, if I run the following conosle command:
mysql --user=root mysql

I receive the following error:
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'mysql'

I can not assign privileges with this comand:
grant all privileges on *.* to 'root'@'localhost' with grant option;

show the same access denied error.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

If I run the command:
show grants for 'root'@'localhost';

It shows:
+------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                    |
+------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*5B630A1B74B9D161A25D1EF8A32578303001CE8A' |
| GRANT ALL PRIVILEGES ON `zabbixdb`.* TO 'root'@'localhost'                                                    |
+------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

What can I do?

[CharlieBrady]

What can I do?

You can follow the instructions you have already been given:

http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password

[d_loayza]

I have followed teh two indications, had done before and I did it again. Don´t show any   error, but in the end as usual still  with the same mistakes I mentioned earlier.

What can I do?

[Stefano]

what do you get doing

Code: [Select]

mysql
?

[d_loayza]

Stefano said:

  what do you get doing?

The answer:

1) install freePBX, which I can not do because the script fails to access the database with the user "root"

2) Fix the problems it generates in the webmail

3) Fix the problems it generates in the startup scripts at server start.

4) Save time by not having the need to make a backup of data and a clean installation.

Please enlighten my brain!

Thanks!

[janet]

d_loayza

Stefano is asking you to login to the Linux command prompt as root user and then type the command

mysql
then press Enter
and then observe what response the system gives you.
Advise back here what you see.
Doing this is part of diagnosing what your problem is.
Until the problem is correctly identified, no one can tell you how to fix it.

[CharlieBrady]

Stefano is asking you to login to the Linux command prompt as root user and then type the command

mysql
then press Enter
and then observe what response the system gives you.
Advise back here what you see.

No, I'd suggest that he posts that to the bug tracker. If there is a problem in the software, it will be fixed. If there is a problem in d_loayza's actions, they will be identified and the bug will be closed INVALID.

[d_loayza]

I am Sorry Stefano, my English is of caveman. I love the Google´s language tools.

The command "mysql" works well, I enter the console but I can not do anything, not even create a database

Look:

[root@linux-server ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 115 to server version: 4.1.22

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

mysql> CREATE DATABASE testing;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'testing'
mysql>

[cactus]

Did you already try to recreate the root user following this instructions: http://wiki.contribs.org/SME_Server:Documentation:FAQ#Restoring_accidently_deleted_MySQL_root_user ?

It could be that not all steps are required as you still seem to have the root user, although there has been some changes to it's privileges as it seems from:

The command "mysql" works well, I enter the console but I can not do anything, not even create a database

[d_loayza]

I followed these instructions step by step, twice.

As might delete the root user of MySQL?, In order to recreate it.
How might to assign all privileges to root user?
As could create another user with sufficient privileges to give privileges to root user?

Here is some einstein?

[Stefano]

how much data have you got into mysql? do you have any db other than horde, mysql and test?