[SOLVED] mysql Access denied

mathio13 · 2017-09-24 11:35:52

hello
need help I cant access mysql and add user in mysql or edit db

I am using
sudo mysqld_safe --skip-grant-tables
FLUSH PRIVILEGES;
output: Access denied
/usr/bin/mysql_secure_installation: line 248: .my.cnf.14238: Permission denied
output: Access denied
how I can fix it

Last edited by mathio13 (2017-10-01 01:04:49)

Trilby · 2017-09-24 11:45:03

The error is pretty clear, the secure_installation script is trying to write to a file but lacks permission.

You are supposed to run that command as root, not with sudo.

https://wiki.archlinux.org/index.php/He … er_or_root

Last edited by Trilby (2017-09-24 11:46:04)

mathio13 · 2017-09-25 15:03:17

thank you #Trilby I fix it it using just this :
$ mkinitcpio -p linux
$ reboot
WORKED

Last edited by mathio13 (2017-09-25 15:03:37)

Trilby · 2017-09-25 15:11:50

*headdesk*

Those steps have absolutely nothing to do with your problem or the solution. I gather when you ran it again after the reboot you did it properly as root. The rebuild of the initramfs was just a conincidence.

In any case, if this is working, please edit your first post to mark it as [SOLVED].

Arch Linux

#1 2017-09-24 11:35:52

[SOLVED] mysql Access denied

#2 2017-09-24 11:45:03

Re: [SOLVED] mysql Access denied

#3 2017-09-25 15:03:17

Re: [SOLVED] mysql Access denied

#4 2017-09-25 15:11:50

Re: [SOLVED] mysql Access denied

Board footer