ERROR 1227 (42000) at line 2706: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation

Community Support Database
1

I know is not about hestia, but maybe someone can help with this : i already added the persion
GRANT ALL PRIVILEGES ON *.* TO 'dapps'@'%';

and also flushing after but still get the error wen i try to import db (the db is to big thats why i import from command line) Thank you

2

Database User Permissions: Ensure that the user dapps@% has the necessary privileges. Since you’ve granted all privileges, also ensure that you did it correctly. Here’s the correct command:

GRANT ALL PRIVILEGES ON . TO ‘dapps’@‘%’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

  • File Permissions: Ensure that the user running the import command has the necessary permissions to read the database file. Check the file permissions on the .sql file to ensure it is readable by the user.
  • MySQL Configuration: Sometimes, large imports can be restricted by MySQL configuration settings. You might need to adjust the following settings in your my.cnf or my.ini file:
  • max_allowed_packet: Increase this value to allow larger packets.
  • innodb_buffer_pool_size: Increase this to allow more InnoDB buffer pool space

[mysqld]
max_allowed_packet=512M
innodb_buffer_pool_size=1G

and

mysql -u dapps -p --max_allowed_packet=512M < yourdatabase.sql

1 Like
3

I dont know if its good or bad but this seems to fix the problem

GRANT SUPER ON *.* TO dapps@localhost;

(PS : my db has more the 1GB if i will use that import command need to make it bigger)

Thank you for the answer Alex_Black

4

Adjust MySQL Configuration

Modify the MySQL server configuration (my.cnf or my.ini file) to allow larger import sizes.

[mysqld]
max_allowed_packet = 1G
net_buffer_length = 16K

Use mysqlimport with Options

mysqlimport --local --user=username --password=yourpassword --host=localhost --default-character-set=utf8 --max-allowed-packet=1G --net-buffer-length=16K yourdatabase /path/to/your/file.csv
``
I hope this can be useful to you.