mySQL how to fix user after I mistakenly added localhost to user instead of 127.0.0.1












-1














I wanted to remove unnecessary users, change passwords and hosts from mySQL as somebody started inserting data into my database.



I removed all users except the one my database is using called forge.
For that user I have replaced % in host/server with 127.0.0.1 and that all works fine on the test database.



On my production database I deleted all users expect forge, and made a mistake by entering localhost instead of 127.0.0.1.



Now the site cannot access the database.
I also have access to the console and I cannot login to mysql:



ERROR 1045 (28000): Access denied for user 'forge'@'localhost' (using password:)



I have searched everywhere for the solution, and tried many things, but the issue remains.
I tried skip-grant-tables and also using mysqld --init-file where I tried to change the users settings, but nothing helped.



Any ideas are welcome. I do not want to use backup as it is old and I would lose a lot of data.



Service is running

service mysql status

mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en

   Active: active (running) since Mon 2018-12-24 17:37:22 UTC; 41min ago

  Process: 3291 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/my

  Process: 3282 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit

 Main PID: 3293 (mysqld)

    Tasks: 28 (limit: 1158)

   CGroup: /system.slice/mysql.service

           └─3293 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid


I am also getting errors like:



2018-12-24T18:36:53.029878Z 0 [Warning] TIMESTAMP with implicit DEFAULT value i.

2018-12-24T18:36:53.030026Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.030059Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) st.

2018-12-24T18:36:53.033961Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.033976Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.034275Z 0 [Warning] One can only use the --user switch if rt



2018-12-24T18:36:53.034446Z 0 [ERROR] Could not open file '/var/log/mysql/errord

2018-12-24T18:36:53.042201Z 0 [ERROR] Aborting



2018-12-24T18:36:53.042807Z 0 [Note] Binlog end

2018-12-24T18:36:53.043396Z 0 [Note] mysqld: Shutdown complete


As well as 



ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/ru)


LOGS



2018-12-25T14:44:24.211390Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details).

2018-12-25T14:44:24.213508Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 28769 ...

2018-12-25T14:44:24.218278Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:44:24.218310Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:44:24.218314Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:44:24.218318Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:44:24.218321Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:44:24.218324Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:44:24.218577Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:44:24.218683Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:44:24.220346Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:44:24.234602Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:44:24.238742Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:44:24.265021Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-12-25T14:44:24.265092Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12MB. Physically writing the file full; Please wait ...

2018-12-25T14:44:24.287401Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:44:24.288164Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:44:24.288175Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:44:24.288497Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:44:24.338698Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120393

2018-12-25T14:44:24.339090Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:44:24.339388Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.343947Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:44:24

2018-12-25T14:44:24.347901Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:44:24.347915Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:44:24.347990Z 0 [Note] IPv6 is available.

2018-12-25T14:44:24.347996Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:44:24.348020Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:44:24.348058Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.

2018-12-25T14:44:24.348062Z 0 [ERROR] Unable to setup unix socket lock file.

2018-12-25T14:44:24.348065Z 0 [ERROR] Aborting



2018-12-25T14:44:24.348071Z 0 [Note] Binlog end

2018-12-25T14:44:24.348116Z 0 [Note] Shutting down plugin 'auth_socket'

2018-12-25T14:44:24.348121Z 0 [Note] Shutting down plugin 'ngram'

2018-12-25T14:44:24.348123Z 0 [Note] Shutting down plugin 'partition'

2018-12-25T14:44:24.348126Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2018-12-25T14:44:24.348128Z 0 [Note] Shutting down plugin 'ARCHIVE'

2018-12-25T14:44:24.348130Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2018-12-25T14:44:24.348179Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2018-12-25T14:44:24.348182Z 0 [Note] Shutting down plugin 'MyISAM'

2018-12-25T14:44:24.348192Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2018-12-25T14:44:24.348195Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2018-12-25T14:44:24.348198Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2018-12-25T14:44:24.348200Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2018-12-25T14:44:24.348202Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2018-12-25T14:44:24.348204Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2018-12-25T14:44:24.348215Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2018-12-25T14:44:24.348217Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2018-12-25T14:44:24.348219Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2018-12-25T14:44:24.348221Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2018-12-25T14:44:24.348223Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2018-12-25T14:44:24.348225Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2018-12-25T14:44:24.348227Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2018-12-25T14:44:24.348229Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2018-12-25T14:44:24.348231Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2018-12-25T14:44:24.348233Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2018-12-25T14:44:24.348235Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2018-12-25T14:44:24.348237Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2018-12-25T14:44:24.348238Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2018-12-25T14:44:24.348240Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2018-12-25T14:44:24.348242Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2018-12-25T14:44:24.348244Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2018-12-25T14:44:24.348246Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2018-12-25T14:44:24.348248Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2018-12-25T14:44:24.348250Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2018-12-25T14:44:24.348252Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2018-12-25T14:44:24.348254Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2018-12-25T14:44:24.348256Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2018-12-25T14:44:24.348258Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2018-12-25T14:44:24.348260Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2018-12-25T14:44:24.348262Z 0 [Note] Shutting down plugin 'InnoDB'

2018-12-25T14:44:24.348334Z 0 [Note] InnoDB: FTS optimize thread exiting.

2018-12-25T14:44:24.348485Z 0 [Note] InnoDB: Starting shutdown...

2018-12-25T14:44:24.448847Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.449063Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181225 14:44:24

2018-12-25T14:44:25.957567Z 0 [Note] InnoDB: Shutdown completed; log sequence number 123120412

2018-12-25T14:44:25.959808Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-12-25T14:44:25.959831Z 0 [Note] Shutting down plugin 'MEMORY'

2018-12-25T14:44:25.959839Z 0 [Note] Shutting down plugin 'CSV'

2018-12-25T14:44:25.959844Z 0 [Note] Shutting down plugin 'sha256_password'

2018-12-25T14:44:25.959847Z 0 [Note] Shutting down plugin 'mysql_native_password'

2018-12-25T14:44:25.960071Z 0 [Note] Shutting down plugin 'binlog'

2018-12-25T14:44:25.960297Z 0 [Note] mysqld: Shutdown complete



2018-12-25T14:45:18.574624Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-12-25T14:45:18.576730Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 29019 ...

2018-12-25T14:45:18.580978Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:45:18.581003Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:45:18.581007Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:45:18.581010Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:45:18.581014Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:45:18.581017Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:45:18.581264Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:45:18.581374Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:45:18.582997Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:45:18.591560Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:45:18.593907Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:45:18.605972Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-12-25T14:45:18.620997Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables



2018-12-25T14:45:18.621068Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-12-25T14:45:18.642100Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:45:18.642948Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:45:18.642960Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:45:18.643253Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:45:18.693516Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120412

2018-12-25T14:45:18.693923Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:45:18.699135Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:45:18.699162Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:45:18.699301Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:45:18.699521Z 0 [Note] IPv6 is available.

2018-12-25T14:45:18.699531Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:45:18.699555Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:45:18.700926Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:45:18

2018-12-25T14:45:18.728760Z 0 [Note] Event Scheduler: Loaded 0 events

2018-12-25T14:45:18.728960Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.24-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

2018-12-25T14:45:19.028308Z 2 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:20.394050Z 3 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:21.501361Z 4 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:22.616129Z 5 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:23.728224Z 6 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:24.840142Z 7 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:25.946301Z 8 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:29.266520Z 11 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:30.377526Z 12 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:31.481280Z 13 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:32.578283Z 14 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:33.136082Z 15 [Note] Access denied for user 'username'@'localhost' (using password: YES)

2018-12-25T14:45:33.683151Z 16 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:34.781366Z 17 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:35.876729Z 18 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:36.977013Z 19 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:38.083751Z 20 [Note] Access denied for user 'forge'@'localhost' (using password: YES)





mysql







share|improve this question
























  • Please add full logs
    – Tomasz Jakub Rup
    Dec 24 '18 at 21:08










  • Added error.log
    – Apps Force
    Dec 25 '18 at 14:56










  • I tried also creating a new user using: GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'::1' IDENTIFIED BY 'password'; and loading via file. However I cannot log in as seen in logs
    – Apps Force
    Dec 25 '18 at 14:56


















-1














I wanted to remove unnecessary users, change passwords and hosts from mySQL as somebody started inserting data into my database.



I removed all users except the one my database is using called forge.
For that user I have replaced % in host/server with 127.0.0.1 and that all works fine on the test database.



On my production database I deleted all users expect forge, and made a mistake by entering localhost instead of 127.0.0.1.



Now the site cannot access the database.
I also have access to the console and I cannot login to mysql:



ERROR 1045 (28000): Access denied for user 'forge'@'localhost' (using password:)



I have searched everywhere for the solution, and tried many things, but the issue remains.
I tried skip-grant-tables and also using mysqld --init-file where I tried to change the users settings, but nothing helped.



Any ideas are welcome. I do not want to use backup as it is old and I would lose a lot of data.



Service is running

service mysql status

mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en

   Active: active (running) since Mon 2018-12-24 17:37:22 UTC; 41min ago

  Process: 3291 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/my

  Process: 3282 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit

 Main PID: 3293 (mysqld)

    Tasks: 28 (limit: 1158)

   CGroup: /system.slice/mysql.service

           └─3293 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid


I am also getting errors like:



2018-12-24T18:36:53.029878Z 0 [Warning] TIMESTAMP with implicit DEFAULT value i.

2018-12-24T18:36:53.030026Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.030059Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) st.

2018-12-24T18:36:53.033961Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.033976Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.034275Z 0 [Warning] One can only use the --user switch if rt



2018-12-24T18:36:53.034446Z 0 [ERROR] Could not open file '/var/log/mysql/errord

2018-12-24T18:36:53.042201Z 0 [ERROR] Aborting



2018-12-24T18:36:53.042807Z 0 [Note] Binlog end

2018-12-24T18:36:53.043396Z 0 [Note] mysqld: Shutdown complete


As well as 



ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/ru)


LOGS



2018-12-25T14:44:24.211390Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details).

2018-12-25T14:44:24.213508Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 28769 ...

2018-12-25T14:44:24.218278Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:44:24.218310Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:44:24.218314Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:44:24.218318Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:44:24.218321Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:44:24.218324Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:44:24.218577Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:44:24.218683Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:44:24.220346Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:44:24.234602Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:44:24.238742Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:44:24.265021Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-12-25T14:44:24.265092Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12MB. Physically writing the file full; Please wait ...

2018-12-25T14:44:24.287401Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:44:24.288164Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:44:24.288175Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:44:24.288497Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:44:24.338698Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120393

2018-12-25T14:44:24.339090Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:44:24.339388Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.343947Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:44:24

2018-12-25T14:44:24.347901Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:44:24.347915Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:44:24.347990Z 0 [Note] IPv6 is available.

2018-12-25T14:44:24.347996Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:44:24.348020Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:44:24.348058Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.

2018-12-25T14:44:24.348062Z 0 [ERROR] Unable to setup unix socket lock file.

2018-12-25T14:44:24.348065Z 0 [ERROR] Aborting



2018-12-25T14:44:24.348071Z 0 [Note] Binlog end

2018-12-25T14:44:24.348116Z 0 [Note] Shutting down plugin 'auth_socket'

2018-12-25T14:44:24.348121Z 0 [Note] Shutting down plugin 'ngram'

2018-12-25T14:44:24.348123Z 0 [Note] Shutting down plugin 'partition'

2018-12-25T14:44:24.348126Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2018-12-25T14:44:24.348128Z 0 [Note] Shutting down plugin 'ARCHIVE'

2018-12-25T14:44:24.348130Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2018-12-25T14:44:24.348179Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2018-12-25T14:44:24.348182Z 0 [Note] Shutting down plugin 'MyISAM'

2018-12-25T14:44:24.348192Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2018-12-25T14:44:24.348195Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2018-12-25T14:44:24.348198Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2018-12-25T14:44:24.348200Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2018-12-25T14:44:24.348202Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2018-12-25T14:44:24.348204Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2018-12-25T14:44:24.348215Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2018-12-25T14:44:24.348217Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2018-12-25T14:44:24.348219Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2018-12-25T14:44:24.348221Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2018-12-25T14:44:24.348223Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2018-12-25T14:44:24.348225Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2018-12-25T14:44:24.348227Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2018-12-25T14:44:24.348229Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2018-12-25T14:44:24.348231Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2018-12-25T14:44:24.348233Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2018-12-25T14:44:24.348235Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2018-12-25T14:44:24.348237Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2018-12-25T14:44:24.348238Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2018-12-25T14:44:24.348240Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2018-12-25T14:44:24.348242Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2018-12-25T14:44:24.348244Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2018-12-25T14:44:24.348246Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2018-12-25T14:44:24.348248Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2018-12-25T14:44:24.348250Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2018-12-25T14:44:24.348252Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2018-12-25T14:44:24.348254Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2018-12-25T14:44:24.348256Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2018-12-25T14:44:24.348258Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2018-12-25T14:44:24.348260Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2018-12-25T14:44:24.348262Z 0 [Note] Shutting down plugin 'InnoDB'

2018-12-25T14:44:24.348334Z 0 [Note] InnoDB: FTS optimize thread exiting.

2018-12-25T14:44:24.348485Z 0 [Note] InnoDB: Starting shutdown...

2018-12-25T14:44:24.448847Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.449063Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181225 14:44:24

2018-12-25T14:44:25.957567Z 0 [Note] InnoDB: Shutdown completed; log sequence number 123120412

2018-12-25T14:44:25.959808Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-12-25T14:44:25.959831Z 0 [Note] Shutting down plugin 'MEMORY'

2018-12-25T14:44:25.959839Z 0 [Note] Shutting down plugin 'CSV'

2018-12-25T14:44:25.959844Z 0 [Note] Shutting down plugin 'sha256_password'

2018-12-25T14:44:25.959847Z 0 [Note] Shutting down plugin 'mysql_native_password'

2018-12-25T14:44:25.960071Z 0 [Note] Shutting down plugin 'binlog'

2018-12-25T14:44:25.960297Z 0 [Note] mysqld: Shutdown complete



2018-12-25T14:45:18.574624Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-12-25T14:45:18.576730Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 29019 ...

2018-12-25T14:45:18.580978Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:45:18.581003Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:45:18.581007Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:45:18.581010Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:45:18.581014Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:45:18.581017Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:45:18.581264Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:45:18.581374Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:45:18.582997Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:45:18.591560Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:45:18.593907Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:45:18.605972Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-12-25T14:45:18.620997Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables



2018-12-25T14:45:18.621068Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-12-25T14:45:18.642100Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:45:18.642948Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:45:18.642960Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:45:18.643253Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:45:18.693516Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120412

2018-12-25T14:45:18.693923Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:45:18.699135Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:45:18.699162Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:45:18.699301Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:45:18.699521Z 0 [Note] IPv6 is available.

2018-12-25T14:45:18.699531Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:45:18.699555Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:45:18.700926Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:45:18

2018-12-25T14:45:18.728760Z 0 [Note] Event Scheduler: Loaded 0 events

2018-12-25T14:45:18.728960Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.24-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

2018-12-25T14:45:19.028308Z 2 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:20.394050Z 3 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:21.501361Z 4 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:22.616129Z 5 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:23.728224Z 6 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:24.840142Z 7 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:25.946301Z 8 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:29.266520Z 11 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:30.377526Z 12 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:31.481280Z 13 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:32.578283Z 14 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:33.136082Z 15 [Note] Access denied for user 'username'@'localhost' (using password: YES)

2018-12-25T14:45:33.683151Z 16 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:34.781366Z 17 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:35.876729Z 18 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:36.977013Z 19 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:38.083751Z 20 [Note] Access denied for user 'forge'@'localhost' (using password: YES)





mysql







share|improve this question
























  • Please add full logs
    – Tomasz Jakub Rup
    Dec 24 '18 at 21:08










  • Added error.log
    – Apps Force
    Dec 25 '18 at 14:56










  • I tried also creating a new user using: GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'::1' IDENTIFIED BY 'password'; and loading via file. However I cannot log in as seen in logs
    – Apps Force
    Dec 25 '18 at 14:56
















-1












-1








-1







I wanted to remove unnecessary users, change passwords and hosts from mySQL as somebody started inserting data into my database.



I removed all users except the one my database is using called forge.
For that user I have replaced % in host/server with 127.0.0.1 and that all works fine on the test database.



On my production database I deleted all users expect forge, and made a mistake by entering localhost instead of 127.0.0.1.



Now the site cannot access the database.
I also have access to the console and I cannot login to mysql:



ERROR 1045 (28000): Access denied for user 'forge'@'localhost' (using password:)



I have searched everywhere for the solution, and tried many things, but the issue remains.
I tried skip-grant-tables and also using mysqld --init-file where I tried to change the users settings, but nothing helped.



Any ideas are welcome. I do not want to use backup as it is old and I would lose a lot of data.



Service is running

service mysql status

mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en

   Active: active (running) since Mon 2018-12-24 17:37:22 UTC; 41min ago

  Process: 3291 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/my

  Process: 3282 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit

 Main PID: 3293 (mysqld)

    Tasks: 28 (limit: 1158)

   CGroup: /system.slice/mysql.service

           └─3293 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid


I am also getting errors like:



2018-12-24T18:36:53.029878Z 0 [Warning] TIMESTAMP with implicit DEFAULT value i.

2018-12-24T18:36:53.030026Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.030059Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) st.

2018-12-24T18:36:53.033961Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.033976Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.034275Z 0 [Warning] One can only use the --user switch if rt



2018-12-24T18:36:53.034446Z 0 [ERROR] Could not open file '/var/log/mysql/errord

2018-12-24T18:36:53.042201Z 0 [ERROR] Aborting



2018-12-24T18:36:53.042807Z 0 [Note] Binlog end

2018-12-24T18:36:53.043396Z 0 [Note] mysqld: Shutdown complete


As well as 



ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/ru)


LOGS



2018-12-25T14:44:24.211390Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details).

2018-12-25T14:44:24.213508Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 28769 ...

2018-12-25T14:44:24.218278Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:44:24.218310Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:44:24.218314Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:44:24.218318Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:44:24.218321Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:44:24.218324Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:44:24.218577Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:44:24.218683Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:44:24.220346Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:44:24.234602Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:44:24.238742Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:44:24.265021Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-12-25T14:44:24.265092Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12MB. Physically writing the file full; Please wait ...

2018-12-25T14:44:24.287401Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:44:24.288164Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:44:24.288175Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:44:24.288497Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:44:24.338698Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120393

2018-12-25T14:44:24.339090Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:44:24.339388Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.343947Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:44:24

2018-12-25T14:44:24.347901Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:44:24.347915Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:44:24.347990Z 0 [Note] IPv6 is available.

2018-12-25T14:44:24.347996Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:44:24.348020Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:44:24.348058Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.

2018-12-25T14:44:24.348062Z 0 [ERROR] Unable to setup unix socket lock file.

2018-12-25T14:44:24.348065Z 0 [ERROR] Aborting



2018-12-25T14:44:24.348071Z 0 [Note] Binlog end

2018-12-25T14:44:24.348116Z 0 [Note] Shutting down plugin 'auth_socket'

2018-12-25T14:44:24.348121Z 0 [Note] Shutting down plugin 'ngram'

2018-12-25T14:44:24.348123Z 0 [Note] Shutting down plugin 'partition'

2018-12-25T14:44:24.348126Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2018-12-25T14:44:24.348128Z 0 [Note] Shutting down plugin 'ARCHIVE'

2018-12-25T14:44:24.348130Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2018-12-25T14:44:24.348179Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2018-12-25T14:44:24.348182Z 0 [Note] Shutting down plugin 'MyISAM'

2018-12-25T14:44:24.348192Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2018-12-25T14:44:24.348195Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2018-12-25T14:44:24.348198Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2018-12-25T14:44:24.348200Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2018-12-25T14:44:24.348202Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2018-12-25T14:44:24.348204Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2018-12-25T14:44:24.348215Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2018-12-25T14:44:24.348217Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2018-12-25T14:44:24.348219Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2018-12-25T14:44:24.348221Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2018-12-25T14:44:24.348223Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2018-12-25T14:44:24.348225Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2018-12-25T14:44:24.348227Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2018-12-25T14:44:24.348229Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2018-12-25T14:44:24.348231Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2018-12-25T14:44:24.348233Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2018-12-25T14:44:24.348235Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2018-12-25T14:44:24.348237Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2018-12-25T14:44:24.348238Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2018-12-25T14:44:24.348240Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2018-12-25T14:44:24.348242Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2018-12-25T14:44:24.348244Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2018-12-25T14:44:24.348246Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2018-12-25T14:44:24.348248Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2018-12-25T14:44:24.348250Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2018-12-25T14:44:24.348252Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2018-12-25T14:44:24.348254Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2018-12-25T14:44:24.348256Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2018-12-25T14:44:24.348258Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2018-12-25T14:44:24.348260Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2018-12-25T14:44:24.348262Z 0 [Note] Shutting down plugin 'InnoDB'

2018-12-25T14:44:24.348334Z 0 [Note] InnoDB: FTS optimize thread exiting.

2018-12-25T14:44:24.348485Z 0 [Note] InnoDB: Starting shutdown...

2018-12-25T14:44:24.448847Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.449063Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181225 14:44:24

2018-12-25T14:44:25.957567Z 0 [Note] InnoDB: Shutdown completed; log sequence number 123120412

2018-12-25T14:44:25.959808Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-12-25T14:44:25.959831Z 0 [Note] Shutting down plugin 'MEMORY'

2018-12-25T14:44:25.959839Z 0 [Note] Shutting down plugin 'CSV'

2018-12-25T14:44:25.959844Z 0 [Note] Shutting down plugin 'sha256_password'

2018-12-25T14:44:25.959847Z 0 [Note] Shutting down plugin 'mysql_native_password'

2018-12-25T14:44:25.960071Z 0 [Note] Shutting down plugin 'binlog'

2018-12-25T14:44:25.960297Z 0 [Note] mysqld: Shutdown complete



2018-12-25T14:45:18.574624Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-12-25T14:45:18.576730Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 29019 ...

2018-12-25T14:45:18.580978Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:45:18.581003Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:45:18.581007Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:45:18.581010Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:45:18.581014Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:45:18.581017Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:45:18.581264Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:45:18.581374Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:45:18.582997Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:45:18.591560Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:45:18.593907Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:45:18.605972Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-12-25T14:45:18.620997Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables



2018-12-25T14:45:18.621068Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-12-25T14:45:18.642100Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:45:18.642948Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:45:18.642960Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:45:18.643253Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:45:18.693516Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120412

2018-12-25T14:45:18.693923Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:45:18.699135Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:45:18.699162Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:45:18.699301Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:45:18.699521Z 0 [Note] IPv6 is available.

2018-12-25T14:45:18.699531Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:45:18.699555Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:45:18.700926Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:45:18

2018-12-25T14:45:18.728760Z 0 [Note] Event Scheduler: Loaded 0 events

2018-12-25T14:45:18.728960Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.24-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

2018-12-25T14:45:19.028308Z 2 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:20.394050Z 3 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:21.501361Z 4 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:22.616129Z 5 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:23.728224Z 6 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:24.840142Z 7 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:25.946301Z 8 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:29.266520Z 11 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:30.377526Z 12 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:31.481280Z 13 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:32.578283Z 14 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:33.136082Z 15 [Note] Access denied for user 'username'@'localhost' (using password: YES)

2018-12-25T14:45:33.683151Z 16 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:34.781366Z 17 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:35.876729Z 18 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:36.977013Z 19 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:38.083751Z 20 [Note] Access denied for user 'forge'@'localhost' (using password: YES)





mysql







share|improve this question















I wanted to remove unnecessary users, change passwords and hosts from mySQL as somebody started inserting data into my database.



I removed all users except the one my database is using called forge.
For that user I have replaced % in host/server with 127.0.0.1 and that all works fine on the test database.



On my production database I deleted all users expect forge, and made a mistake by entering localhost instead of 127.0.0.1.



Now the site cannot access the database.
I also have access to the console and I cannot login to mysql:



ERROR 1045 (28000): Access denied for user 'forge'@'localhost' (using password:)



I have searched everywhere for the solution, and tried many things, but the issue remains.
I tried skip-grant-tables and also using mysqld --init-file where I tried to change the users settings, but nothing helped.



Any ideas are welcome. I do not want to use backup as it is old and I would lose a lot of data.



Service is running

service mysql status

mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en

   Active: active (running) since Mon 2018-12-24 17:37:22 UTC; 41min ago

  Process: 3291 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/my

  Process: 3282 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit

 Main PID: 3293 (mysqld)

    Tasks: 28 (limit: 1158)

   CGroup: /system.slice/mysql.service

           └─3293 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid


I am also getting errors like:



2018-12-24T18:36:53.029878Z 0 [Warning] TIMESTAMP with implicit DEFAULT value i.

2018-12-24T18:36:53.030026Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.030059Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) st.

2018-12-24T18:36:53.033961Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.033976Z 0 [Warning] Can't create test file /var/lib/mysql/At

2018-12-24T18:36:53.034275Z 0 [Warning] One can only use the --user switch if rt



2018-12-24T18:36:53.034446Z 0 [ERROR] Could not open file '/var/log/mysql/errord

2018-12-24T18:36:53.042201Z 0 [ERROR] Aborting



2018-12-24T18:36:53.042807Z 0 [Note] Binlog end

2018-12-24T18:36:53.043396Z 0 [Note] mysqld: Shutdown complete


As well as 



ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/ru)


LOGS



2018-12-25T14:44:24.211390Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details).

2018-12-25T14:44:24.213508Z 0 [Note] mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 28769 ...

2018-12-25T14:44:24.218278Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:44:24.218310Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:44:24.218314Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:44:24.218318Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:44:24.218321Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:44:24.218324Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:44:24.218577Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:44:24.218683Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:44:24.220346Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:44:24.234602Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:44:24.238742Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:44:24.265021Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-12-25T14:44:24.265092Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12MB. Physically writing the file full; Please wait ...

2018-12-25T14:44:24.287401Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:44:24.288164Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:44:24.288175Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:44:24.288497Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:44:24.338698Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120393

2018-12-25T14:44:24.339090Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:44:24.339388Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.343947Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:44:24

2018-12-25T14:44:24.347901Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:44:24.347915Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:44:24.347990Z 0 [Note] IPv6 is available.

2018-12-25T14:44:24.347996Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:44:24.348020Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:44:24.348058Z 0 [ERROR] Could not create unix socket lock file /var/run/mysqld/mysqld.sock.lock.

2018-12-25T14:44:24.348062Z 0 [ERROR] Unable to setup unix socket lock file.

2018-12-25T14:44:24.348065Z 0 [ERROR] Aborting



2018-12-25T14:44:24.348071Z 0 [Note] Binlog end

2018-12-25T14:44:24.348116Z 0 [Note] Shutting down plugin 'auth_socket'

2018-12-25T14:44:24.348121Z 0 [Note] Shutting down plugin 'ngram'

2018-12-25T14:44:24.348123Z 0 [Note] Shutting down plugin 'partition'

2018-12-25T14:44:24.348126Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2018-12-25T14:44:24.348128Z 0 [Note] Shutting down plugin 'ARCHIVE'

2018-12-25T14:44:24.348130Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2018-12-25T14:44:24.348179Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2018-12-25T14:44:24.348182Z 0 [Note] Shutting down plugin 'MyISAM'

2018-12-25T14:44:24.348192Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2018-12-25T14:44:24.348195Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2018-12-25T14:44:24.348198Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2018-12-25T14:44:24.348200Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2018-12-25T14:44:24.348202Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2018-12-25T14:44:24.348204Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2018-12-25T14:44:24.348215Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2018-12-25T14:44:24.348217Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2018-12-25T14:44:24.348219Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2018-12-25T14:44:24.348221Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2018-12-25T14:44:24.348223Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2018-12-25T14:44:24.348225Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2018-12-25T14:44:24.348227Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2018-12-25T14:44:24.348229Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2018-12-25T14:44:24.348231Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2018-12-25T14:44:24.348233Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2018-12-25T14:44:24.348235Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2018-12-25T14:44:24.348237Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2018-12-25T14:44:24.348238Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2018-12-25T14:44:24.348240Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2018-12-25T14:44:24.348242Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2018-12-25T14:44:24.348244Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2018-12-25T14:44:24.348246Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2018-12-25T14:44:24.348248Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2018-12-25T14:44:24.348250Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2018-12-25T14:44:24.348252Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2018-12-25T14:44:24.348254Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2018-12-25T14:44:24.348256Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2018-12-25T14:44:24.348258Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2018-12-25T14:44:24.348260Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2018-12-25T14:44:24.348262Z 0 [Note] Shutting down plugin 'InnoDB'

2018-12-25T14:44:24.348334Z 0 [Note] InnoDB: FTS optimize thread exiting.

2018-12-25T14:44:24.348485Z 0 [Note] InnoDB: Starting shutdown...

2018-12-25T14:44:24.448847Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool

2018-12-25T14:44:24.449063Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181225 14:44:24

2018-12-25T14:44:25.957567Z 0 [Note] InnoDB: Shutdown completed; log sequence number 123120412

2018-12-25T14:44:25.959808Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2018-12-25T14:44:25.959831Z 0 [Note] Shutting down plugin 'MEMORY'

2018-12-25T14:44:25.959839Z 0 [Note] Shutting down plugin 'CSV'

2018-12-25T14:44:25.959844Z 0 [Note] Shutting down plugin 'sha256_password'

2018-12-25T14:44:25.959847Z 0 [Note] Shutting down plugin 'mysql_native_password'

2018-12-25T14:44:25.960071Z 0 [Note] Shutting down plugin 'binlog'

2018-12-25T14:44:25.960297Z 0 [Note] mysqld: Shutdown complete



2018-12-25T14:45:18.574624Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2018-12-25T14:45:18.576730Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24-0ubuntu0.18.04.1) starting as process 29019 ...

2018-12-25T14:45:18.580978Z 0 [Note] InnoDB: PUNCH HOLE support available

2018-12-25T14:45:18.581003Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-12-25T14:45:18.581007Z 0 [Note] InnoDB: Uses event mutexes

2018-12-25T14:45:18.581010Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier

2018-12-25T14:45:18.581014Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-12-25T14:45:18.581017Z 0 [Note] InnoDB: Using Linux native AIO

2018-12-25T14:45:18.581264Z 0 [Note] InnoDB: Number of pools: 1

2018-12-25T14:45:18.581374Z 0 [Note] InnoDB: Using CPU crc32 instructions

2018-12-25T14:45:18.582997Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-12-25T14:45:18.591560Z 0 [Note] InnoDB: Completed initialization of buffer pool

2018-12-25T14:45:18.593907Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-12-25T14:45:18.605972Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2018-12-25T14:45:18.620997Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables



2018-12-25T14:45:18.621068Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-12-25T14:45:18.642100Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-12-25T14:45:18.642948Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2018-12-25T14:45:18.642960Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2018-12-25T14:45:18.643253Z 0 [Note] InnoDB: Waiting for purge to start

2018-12-25T14:45:18.693516Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 123120412

2018-12-25T14:45:18.693923Z 0 [Note] Plugin 'FEDERATED' is disabled.

2018-12-25T14:45:18.699135Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2018-12-25T14:45:18.699162Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2018-12-25T14:45:18.699301Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-12-25T14:45:18.699521Z 0 [Note] IPv6 is available.

2018-12-25T14:45:18.699531Z 0 [Note]   - '::' resolves to '::';

2018-12-25T14:45:18.699555Z 0 [Note] Server socket created on IP: '::'.

2018-12-25T14:45:18.700926Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181225 14:45:18

2018-12-25T14:45:18.728760Z 0 [Note] Event Scheduler: Loaded 0 events

2018-12-25T14:45:18.728960Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.24-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

2018-12-25T14:45:19.028308Z 2 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:20.394050Z 3 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:21.501361Z 4 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:22.616129Z 5 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:23.728224Z 6 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:24.840142Z 7 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:25.946301Z 8 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:29.266520Z 11 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:30.377526Z 12 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:31.481280Z 13 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:32.578283Z 14 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:33.136082Z 15 [Note] Access denied for user 'username'@'localhost' (using password: YES)

2018-12-25T14:45:33.683151Z 16 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:34.781366Z 17 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:35.876729Z 18 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:36.977013Z 19 [Note] Access denied for user 'forge'@'localhost' (using password: YES)

2018-12-25T14:45:38.083751Z 20 [Note] Access denied for user 'forge'@'localhost' (using password: YES)





mysql




mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Dec 25 '18 at 16:26









Tomasz Jakub Rup

594313




594313










asked Dec 24 '18 at 18:38









Apps ForceApps Force

63




63












  • Please add full logs
    – Tomasz Jakub Rup
    Dec 24 '18 at 21:08










  • Added error.log
    – Apps Force
    Dec 25 '18 at 14:56










  • I tried also creating a new user using: GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'::1' IDENTIFIED BY 'password'; and loading via file. However I cannot log in as seen in logs
    – Apps Force
    Dec 25 '18 at 14:56




















  • Please add full logs
    – Tomasz Jakub Rup
    Dec 24 '18 at 21:08










  • Added error.log
    – Apps Force
    Dec 25 '18 at 14:56










  • I tried also creating a new user using: GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'::1' IDENTIFIED BY 'password'; and loading via file. However I cannot log in as seen in logs
    – Apps Force
    Dec 25 '18 at 14:56


















Please add full logs
– Tomasz Jakub Rup
Dec 24 '18 at 21:08




Please add full logs
– Tomasz Jakub Rup
Dec 24 '18 at 21:08












Added error.log
– Apps Force
Dec 25 '18 at 14:56




Added error.log
– Apps Force
Dec 25 '18 at 14:56












I tried also creating a new user using: GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'::1' IDENTIFIED BY 'password'; and loading via file. However I cannot log in as seen in logs
– Apps Force
Dec 25 '18 at 14:56






I tried also creating a new user using: GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'@'::1' IDENTIFIED BY 'password'; and loading via file. However I cannot log in as seen in logs
– Apps Force
Dec 25 '18 at 14:56












2 Answers
2






active

oldest

votes


















0














Two solutions:





  1. MySQLd was attempting to create the socket and lock file but the parent directory was missing.



    sudo mkdir /var/run/mysqld
    
sudo chown mysql:mysql /var/run/mysqld


  2. Add skip-external-locking to my.cnf under the [mysqld] section, and then reboot the service.






share|improve this answer





















  • I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
    – Apps Force
    Dec 26 '18 at 11:04












  • Try mysql_upgrade -u adminname -p and restart service
    – Tomasz Jakub Rup
    Dec 26 '18 at 12:41



















0














I found a solution.



I copied mysql user files to /var/lib/mysql/mysql
Also hadto chown them to mysql, restart mysql, and I can log in with the users from the backup files.



All databases are preserved.






share|improve this answer





















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1387443%2fmysql-how-to-fix-user-after-i-mistakenly-added-localhost-to-user-instead-of-127%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Two solutions:





    1. MySQLd was attempting to create the socket and lock file but the parent directory was missing.



      sudo mkdir /var/run/mysqld
      
sudo chown mysql:mysql /var/run/mysqld


    2. Add skip-external-locking to my.cnf under the [mysqld] section, and then reboot the service.






    share|improve this answer





















    • I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
      – Apps Force
      Dec 26 '18 at 11:04












    • Try mysql_upgrade -u adminname -p and restart service
      – Tomasz Jakub Rup
      Dec 26 '18 at 12:41
















    0














    Two solutions:





    1. MySQLd was attempting to create the socket and lock file but the parent directory was missing.



      sudo mkdir /var/run/mysqld
      
sudo chown mysql:mysql /var/run/mysqld


    2. Add skip-external-locking to my.cnf under the [mysqld] section, and then reboot the service.






    share|improve this answer





















    • I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
      – Apps Force
      Dec 26 '18 at 11:04












    • Try mysql_upgrade -u adminname -p and restart service
      – Tomasz Jakub Rup
      Dec 26 '18 at 12:41














    0












    0








    0






    Two solutions:





    1. MySQLd was attempting to create the socket and lock file but the parent directory was missing.



      sudo mkdir /var/run/mysqld
      
sudo chown mysql:mysql /var/run/mysqld


    2. Add skip-external-locking to my.cnf under the [mysqld] section, and then reboot the service.






    share|improve this answer












    Two solutions:





    1. MySQLd was attempting to create the socket and lock file but the parent directory was missing.



      sudo mkdir /var/run/mysqld
      
sudo chown mysql:mysql /var/run/mysqld


    2. Add skip-external-locking to my.cnf under the [mysqld] section, and then reboot the service.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Dec 25 '18 at 20:23









    Tomasz Jakub RupTomasz Jakub Rup

    594313




    594313












    • I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
      – Apps Force
      Dec 26 '18 at 11:04












    • Try mysql_upgrade -u adminname -p and restart service
      – Tomasz Jakub Rup
      Dec 26 '18 at 12:41


















    • I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
      – Apps Force
      Dec 26 '18 at 11:04












    • Try mysql_upgrade -u adminname -p and restart service
      – Tomasz Jakub Rup
      Dec 26 '18 at 12:41
















    I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
    – Apps Force
    Dec 26 '18 at 11:04






    I already have that directory and socket and lock files in it. It is owned by the right user/group drwxr-xr-x 2 mysql mysql 100 Dec 25 14:45 mysqld . There is skip-external-locking in my.cnf already. Anything else?
    – Apps Force
    Dec 26 '18 at 11:04














    Try mysql_upgrade -u adminname -p and restart service
    – Tomasz Jakub Rup
    Dec 26 '18 at 12:41




    Try mysql_upgrade -u adminname -p and restart service
    – Tomasz Jakub Rup
    Dec 26 '18 at 12:41













    0














    I found a solution.



    I copied mysql user files to /var/lib/mysql/mysql
    Also hadto chown them to mysql, restart mysql, and I can log in with the users from the backup files.



    All databases are preserved.






    share|improve this answer


























      0














      I found a solution.



      I copied mysql user files to /var/lib/mysql/mysql
      Also hadto chown them to mysql, restart mysql, and I can log in with the users from the backup files.



      All databases are preserved.






      share|improve this answer
























        0












        0








        0






        I found a solution.



        I copied mysql user files to /var/lib/mysql/mysql
        Also hadto chown them to mysql, restart mysql, and I can log in with the users from the backup files.



        All databases are preserved.






        share|improve this answer












        I found a solution.



        I copied mysql user files to /var/lib/mysql/mysql
        Also hadto chown them to mysql, restart mysql, and I can log in with the users from the backup files.



        All databases are preserved.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Dec 26 '18 at 13:05









        Apps ForceApps Force

        63




        63






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1387443%2fmysql-how-to-fix-user-after-i-mistakenly-added-localhost-to-user-instead-of-127%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            flock() on closed filehandle LOCK_FILE at /usr/bin/apt-mirror

            Image
            0 I recently upgraded an Ubuntu 16.04 virtual machine to 18.04. I regularly use this VM to run apt-mirror at school on their high-speed internet, then rsync these files to my rack-mount server at home for updating multiple computers at home without wasting the tiny amount of bandwidth I have there. Since updating I can't get apt-mirror to run on my VM. It keeps giving the error: flock() on closed filehandle LOCK_FILE at /usr/bin/apt-mirror line 214 immediately followed by: apt-mirror is already running, exiting at /usr/bin/apt-mirror line 217 apt-mirror is NOT running, and does not have a cron job. I've tried rebooting, and even looked for the old-style lockfile to delete, but I guess that method is no longer used. Is there some way to force unlock this so I can run apt-mirror? UPDATE: So... I f
            Read more

            Mangá

            Image
              Nota:  Não confundir com Manga. Mangás e Animes Mangá Mangaká • Tankōbon Film comic La nouvelle manga Mangá original em inglês Anime História Animação influenciada por animes • Filler • OVA • Seiyū Públicos Kodomo • Shōjo • Shōnen Josei • Seinen Gêneros Mahō shōjo • Mecha • Harém Ecchi • Hentai ( Yaoi • Yuri Futanari • Shotacon • Lolicon Toddlercon ) Termos Bishōjo • Chibi • Fan service Gaiden • Kawaii • Kaitō • Light novel Mahō shōnen • Moe (antropomorfismo • Kemonomimi Nekomimi ) • Super deformed Omake • Tsundere • Yonkoma Listas Mangás • Animes • Ecchi • Mangaka • Estúdios • Revistas Fãs ( otaku ) Anime Music Video Convenções • Cosplay Dōjinshi • Fansub • Fandub • Fujoshi OS-tan • Scanlation Portal de Anime e mangá v d e O mangá (português brasileiro) ou manga (português europeu) [ 1 ] (em japonês: 漫画 , manga ? , lit. “história em quadrinhos”) , é a
            Read more

             ⁒  ․,‪⁊‑⁙ ⁖, ⁇‒※‌, †,⁖‗‌⁝    ‾‸⁘,‖⁔⁣,⁂‾
”‑,‥–,‬ ,⁀‹⁋‴⁑ ‒ ,‴⁋”‼ ⁨,‷⁔„ ‰′,‐‚ ‥‡‎“‷⁃⁨⁅⁣,⁔
⁇‘⁔⁡⁏⁌⁡‿‶‏⁨ ⁣⁕⁖⁨⁩⁥‽⁀  ‴‬⁜‟ ⁃‣‧⁕‮ …‍⁨‴ ⁩,⁚⁖‫ ,‵ ⁀,‮⁝‣‣ ⁑  ⁂– ․, ‾‽ ‏⁁“⁗‸ ‾… ‹‡⁌⁎‸‘ ‡⁏⁌‪ ‵⁛ ‎⁨ ―⁦⁤⁄⁕

            ⁉…‧ ⁩,“⁡‹⁃‽⁞•,⁠‚  ⁓⁎  ⁜ ‴ ⁥⁡⁎‭,‍‑⁁⁌⁦ ⁁‟⁙‥‒“⁈ ,‪⁧ ⁙‿⁇⁦,⁝‘ ⁎“⁘‫‪,‗‹‛‹⁒  ⁇⁄‗‒•“⁇   ‐ ⁂
‘‛, ‶⁦ ⁇ ​⁞‧ 
,⁏ …‹–⁗⁡⁘⁄ ‏‿‬‟″ ‏⁢⁦⁗⁚⁝‬⁢⁏,⁧″⁍′‖⁂※⁄‘– ‵⁡ ‭⁢⁚,⁅‧,‼‛⁗,⁡⁗“⁔⁃⁍‷⁏‗‱⁌‚  
•⁝ ‚‒ ‥‰  ′⁌, ⁄, ⁛—‭‑”⁂,⁑ ‡⁨‴⁖⁙…,‑, ,⁎,․‣‥  ‴‎⁎,″‛⁎‭‿ ⁤ ‷‾‼‖,⁠⁊‾,⁦“‗‑‌†,⁙,†⁝′ 
,―‚․‘, ⁢  ‿‌,⁀„‣,⁌,‭‖ ⁆“‪,―  ⁀ ⁃,
‷⁥,​,‟‗⁄⁉⁐⁗―
,‮⁢⁩⁆⁣‹‭⁅ ⁝‾‏‭⁖ ⁕⁄‷,†‟‒ ⁣‹,​…​,⁤⁂⁨‮⁎⁙–‟‼ ⁍‱‱,‽,‫‽‣ ⁒,⁨ ⁄ ⁝”„‿‑‎⁈‿
 ⁀‛‼‟ ⁑“,⁩​ ‒
–⁡…⁢ ⁂ ⁈⁎,‵‡,⁛,,‱⁧⁋,․‬⁄ “,⁄‴⁊  ‗―,‵⁙⁔—⁀ —  ⁀‬‬ ‒⁋‼⁀― ,⁌′ ‍‶ ’
            Read more