Cannot create database

[fshagan]

I'm getting this error message when trying to create a new MySQL database in the Direct Admin interface:

"Unable to add user xxxxx_xxxxxx. The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement"

However, looking in /etc/my.cnf I don't see the line "skip-grant-tables" at all, so I'm uncertain why it's running that way.

Things I have tried:
Restart mysqld from within Direct Admin (several times)
Stop and start mysqld from shell / command line
Added skip-grant-tables to /etc/my.cnf restarted mysql, then removed it and restarted mysql.

Any tips on getting this to work?

 

[factor]

try

killall -9 mysqld_safe
killall -9 mysqld
service mysqld start

from

https://help.directadmin.com/item.php?id=45

 

[fshagan]

Thanks for the recommendation! I appreciate the help.

I think I have a more serious problem than the usual with this message. Output of those commands:

[root@host1 public_html]# killall -9 mysqld_safe
mysqld_safe: no process found
[root@host1 public_html]# killall -9 mysqld
[root@host1 public_html]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service

I verified that mysqld was running in Direct Admin. Then tried to create a database again in the user account and get the same message:

Unable to add user xxxxx_xxxxx. The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

 

[factor]

yeah it means your databases are wide open.

Turn off --skip-grant-tables in MySQL

I'm pretty new to using Linux but am setting up my MySQL databases on an Amazon ec2 instance. I followed some directions I found about resetting the user login pass by using the --skip-grant-tables

unix.stackexchange.com

How to disable --skip-grant-tables in MySQL?

I am trying to initialize the database for my OpenGTS installation. However, when I run the shell script that accomplishes this, I get the following error: Version: 2.4.5 Database created: gts [ER...

stackoverflow.com

 

[fshagan]

Thank you very much! Flush privileges did the trick and I can once again create databases.

 

[factor]

Thank you very much! Flush privileges did the trick and I can once again create databases.

Great deal.