Newsgroup: it.comp.os.linux.sys
Titolo: problema connessione con mariadb

 
 
 >  mysql -u root -p
    Enter password:
    ERROR 1045 (28000): Access denied for user
    'root'@'localhost' (using password: YES)
 
 
    [root@localhost ~]# mysqld status
    2017-11-30 13:29:05 140641586747456 [Note] Using unique option
    prefix 'key_buffer' is error-prone and can break in the future.
    Please use the full name 'key_buffer_size' instead. 2017-11-30
    13:29:05 140641586747456 [Note] mysqld (mysqld 10.1.28-MariaDB)
    starting as process 12697 ... handlersocket: initialized 2017-11-30
    13:29:05 140641586747456 [ERROR] mysqld: Can't lock aria control
    file '/var/lib/mysql/aria_log_control' for exclusive use, error:
    11. Will retry for 30 seconds 2017-11-30 13:29:36 140641586747456
    [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is
    probably in use by another process' when trying to use aria control
    file '/var/lib/mysql/aria_log_control' 2017-11-30 13:29:36
    140641586747456 [ERROR] Plugin 'Aria' init function returned error.
    2017-11-30 13:29:36 140641586747456 [ERROR] Plugin 'Aria'
    registration as a STORAGE ENGINE failed. 2017-11-30 13:29:36
    140641586747456 [Note] InnoDB: innodb_empty_free_list_algorithm has
    been changed to legacy because of small buffer pool size. In order
    to use backoff, increase buffer pool at least up to 20MB.
 
    2017-11-30 13:29:36 140641586747456 [Note] InnoDB: Using mutexes to
    ref count buffer pool pages 2017-11-30 13:29:36 140641586747456
    [Note] InnoDB: The InnoDB memory heap is disabled 2017-11-30
    13:29:36 140641586747456 [Note] InnoDB: Mutexes and rw_locks use
    GCC atomic builtins 2017-11-30 13:29:36 140641586747456 [Note]
    InnoDB: GCC builtin __atomic_thread_fence() is used for memory
    barrier 2017-11-30 13:29:36 140641586747456 [Note] InnoDB:
    Compressed tables use zlib 1.2.11 2017-11-30 13:29:36
    140641586747456 [Note] InnoDB: Using Linux native AIO 2017-11-30
    13:29:36 140641586747456 [Note] InnoDB: Using SSE crc32
    instructions 2017-11-30 13:29:36 140641586747456 [Note] InnoDB:
    Initializing buffer pool, size = 128.0M 2017-11-30 13:29:36
    140641586747456 [Note] InnoDB: Completed initialization of buffer
    pool 2017-11-30 13:29:36 140641586747456 [Note] InnoDB: Highest
    supported file format is Barracuda. 2017-11-30 13:29:36
    140641586747456 [Note] InnoDB: 128 rollback segment(s) are active.
    2017-11-30 13:29:36 140641586747456 [Note] InnoDB: Waiting for
    purge to start 2017-11-30 13:29:36 140641586747456 [Note] InnoDB:
    Percona XtraDB (
http://www.percona.com
) 5.6.36-82.2 started; log
    sequence number 1600657 2017-11-30 13:29:36 140641048721152 [Note]
    InnoDB: Dumping buffer pool(s) not yet started 2017-11-30 13:29:36
    140641586747456 [Warning] mysqld: GSSAPI plugin : default principal
    'mariadb/localhost@' not found in keytab 2017-11-30 13:29:36
    140641586747456 [ERROR] mysqld: Server GSSAPI error (major 851968,
    minor 
2529639093
) : gss_acquire_cred failed -Unspecified GSS
    failure.  Minor code may provide more information. Keytab
    FILE:/etc/krb5.keytab is nonexistent or empty. 2017-11-30 13:29:36
    140641586747456 [ERROR] Plugin 'gssapi' init function returned
    error. 171130 13:29:36 server_audit: MariaDB Audit Plugin version
    1.4.2 STARTED. 171130 13:29:36 server_audit: Query cache is enabled
    with the TABLE events. Some table reads can be veiled.mysqld: Too
    many arguments (first extra is 'status'). 2017-11-30 13:29:36
    140641586747456 [ERROR] Aborting
 
    171130 13:29:36 server_audit: STOPPED
    handlersocket: terminated
 
qualche suggerimento?
 
grazie
enrico 

    140641586747456 [ERROR] Aborting
 
Guarda negli init script che cos'hai.
 
Leonardo
 
-- 
 
Ya se escucha sonar la metralla, ya el clarín toca fuego graneado:
ahora o nunca, muchachos arriba a acabar a estos hijos del diablo.

 
 
/etc/init.d]# ls
functions            mandrake_firstime*  network*       numlock*
proftpd*     vnstat* irqbalance*          msec*
network-auth*  partmon*  README mandrake_everytime*
netconsole*         network-up*    preload*  resolvconf*
 
 
Enrico 

netconsole*         network-up*    preload*  resolvconf*
 
...errr... allora forse è meglio provare con:
 
	grep -r /etc mysqld | cut -f1 -d: | uniq -c
 
Sperando che il sistema non sia basato su systemd, che mi fa un certo che
toccare certa roba 'on le mane.


 
 
grep -r /etc mysqld | cut -f1 -d: | uniq -c
grep: mysqld: File o directory non esistente
 
Picche..
 
è una mageia6 
ho istallato il pacchetto server lamp. 
 
la utilizzo come desktop e come server sviluppo web, mai avuto problemi
in tutte le versioni precedenti. 
 
enrico 
 

grep: mysqld: File o directory non esistente
 
Povero me, sono così rimbombato che non mi ricordo la sintassi di grep :-(
 
	grep -r mysqld /etc | cut -f1 -d: | uniq -c


 
 
grep -r mysqld /etc | cut -f1 -d: | uniq -c
      1 /etc/akonadi/mysql-global-mobile.conf
      1 /etc/akonadi/mysql-global.conf
      2 /etc/my.cnf.d/server.cnf
      1 /etc/my.cnf.d/mysql-clients.cnf
      9 /etc/my.cnf
      2 /etc/rc.d/init.d/proftpd
 
Ecco 
Enrico 
 

 ha scritto:
 
trovato grazie al forum mageia 
 
 
In Mageia 6 you MUST use mysql_secure_installation. It was only
recommended before. I just did the procedure bellow due to new install
because of DE switch. Note that you can run it as user and there's no
password set first so you only press Enter (empty password) as written
in script itself.
 
 
 
 
root@localhost ~]# mysql_secure_installation
 
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
 
In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
 
Enter current password for root (enter for none): 
OK, successfully used password, moving on...
 
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
 
You already have a root password set, so you can safely answer 'n'.
 
Change the root password? [Y/n] n
 ... skipping.
 
By default, a MariaDB installation has an anonymous user, allowing
anyone to log into MariaDB without having to have a user account
created for them.  This is intended only for testing, and to make the
installation go a bit smoother.  You should remove them before moving
into a production environment.
 
Remove anonymous users? [Y/n] y
 ... Success!
 
Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.
 
Disallow root login remotely? [Y/n] y
 ... Success!
 
By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production
environment. 
Remove test database and access to it? [Y/n]
y                                                
 - Dropping test
database... ...
Success!                                                                                 
 - Removing privileges on test
database... ...
Success! 
Reloading the privilege tables will ensure that all changes made so
far will take effect
immediately. 
Reload privilege tables now? [Y/n]
y ...
Success! 
Cleaning
up...                                                                                
 
All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.
 
Thanks for using MariaDB!
 
 
 

 
 
 
però...   mi si connette da shell e da phpmyadmn ma no da
MySqlworkbech e mi da una serie di log di errore al riavvio :
 
 
mysqld restart
2017-12-01 10:44:38 139842036406336 [Note] Using unique option prefix
'key_buffer' is error-prone and can break in the future. Please use the
full name 'key_buffer_size' instead. 2017-12-01 10:44:38
139842036406336 [Note] mysqld (mysqld 10.1.28-MariaDB) starting as
process 6866 ... handlersocket: initialized 2017-12-01 10:44:38
139842036406336 [Note] CONNECT: Version 1.06.0004 September 03, 2017
2017-12-01 10:44:38 139842036406336 [ERROR] mysqld: Can't lock aria
control file '/var/lib/mysql/aria_log_control' for exclusive use,
error: 11. Will retry for 30 seconds 2017-12-01 10:45:09
139842036406336 [ERROR] mysqld: Got error 'Could not get an exclusive
lock; file is probably in use by another process' when trying to use
aria control file '/var/lib/mysql/aria_log_control' 2017-12-01 10:45:09
139842036406336 [ERROR] Plugin 'Aria' init function returned error.
2017-12-01 10:45:09 139842036406336 [ERROR] Plugin 'Aria' registration
as a STORAGE ENGINE failed. 2017-12-01 10:45:09 139842036406336 [Note]
InnoDB: innodb_empty_free_list_algorithm has been changed to legacy
because of small buffer pool size. In order to use backoff, increase
buffer pool at least up to 20MB.
 
2017-12-01 10:45:10 139842036406336 [Note] InnoDB: Using mutexes to ref
count buffer pool pages 2017-12-01 10:45:10 139842036406336 [Note]
InnoDB: The InnoDB memory heap is disabled 2017-12-01 10:45:10
139842036406336 [Note] InnoDB: Mutexes and rw_locks use GCC atomic
builtins 2017-12-01 10:45:10 139842036406336 [Note] InnoDB: GCC builtin
__atomic_thread_fence() is used for memory barrier 2017-12-01 10:45:10
139842036406336 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-12-01 10:45:10 139842036406336 [Note] InnoDB: Using Linux native
AIO 2017-12-01 10:45:10 139842036406336 [Note] InnoDB: Using SSE crc32
instructions 2017-12-01 10:45:10 139842036406336 [Note] InnoDB:
Initializing buffer pool, size = 128.0M 2017-12-01 10:45:10
139842036406336 [Note] InnoDB: Completed initialization of buffer pool
2017-12-01 10:45:10 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:10 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:10 139842036406336
[Note] InnoDB: Retrying to lock the first data file 2017-12-01 10:45:11
139842036406336 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
2017-12-01 10:45:11 139842036406336 [Note] InnoDB: Check that you do
not already have another mysqld process using the same InnoDB data or
log files. 2017-12-01 10:45:12 139842036406336 [ERROR] InnoDB: Unable
to lock ./ibdata1, error: 11 2017-12-01 10:45:12 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:13 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:13
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:14 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:14 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:15 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:15
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:16 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:16 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:17 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:17
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:18 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:18 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:19 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:19
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:20 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:20 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:21 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:21
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:22 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:22 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:23 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:23
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:24 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:24 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:25 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:25
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:26 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:26 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:27 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:27
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:28 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:28 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:29 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:29
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:30 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:30 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:31 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:31
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:32 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:32 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:33 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:33
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:34 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:34 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:35 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:35
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:36 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:36 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:37 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:37
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:38 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:38 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:39 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:39
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:40 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:40 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:41 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:41
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:42 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:42 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:43 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:43
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:44 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:44 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:45 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:45
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:46 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:46 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:47 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:47
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:48 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:48 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:49 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:49
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:50 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:50 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:51 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:51
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:52 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:52 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:53 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:53
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
^C2017-12-01 10:45:54 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:54 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:55 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:55
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:56 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:56 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:57 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:57
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:45:58 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:45:58 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:45:59 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:45:59
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:00 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:00 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:01 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:01
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:02 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:02 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:03 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:03
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:04 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:04 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:05 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:05
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:06 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:06 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:07 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:07
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:08 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:08 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:09 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:09
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:10 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:10 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:11 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:11
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:12 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:12 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:13 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:13
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:14 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:14 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:15 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:15
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:16 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:16 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:17 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:17
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:18 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:18 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:19 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:19
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:20 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:20 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:21 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:21
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:22 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:22 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:23 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:23
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:24 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:24 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:25 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:25
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:26 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:26 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:27 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:27
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:28 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:28 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:29 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:29
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:30 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:30 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:31 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:31
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:32 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:32 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:33 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:33
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:34 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:34 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:35 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:35
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:36 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:36 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:37 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:37
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:38 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:38 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:39 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:39
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:40 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:40 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:41 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:41
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:42 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:42 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:43 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:43
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:44 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:44 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:45 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:45
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:46 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:46 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:47 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:47
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:48 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:48 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:49 139842036406336
[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 2017-12-01 10:46:49
139842036406336 [Note] InnoDB: Check that you do not already have
another mysqld process using the same InnoDB data or log files.
2017-12-01 10:46:50 139842036406336 [ERROR] InnoDB: Unable to
lock ./ibdata1, error: 11 2017-12-01 10:46:50 139842036406336 [Note]
InnoDB: Check that you do not already have another mysqld process using
the same InnoDB data or log files. 2017-12-01 10:46:50 139842036406336
[Note] InnoDB: Unable to open the first data file 2017-12-01 10:46:50
7f2f82e79840  InnoDB: Operating system error number 11 in a file
operation. InnoDB: Error number 11 means 'Resource temporarily
unavailable'. InnoDB: Some operating system error numbers are described
at InnoDB:
http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
 
2017-12-01 10:46:50 139842036406336 [ERROR] InnoDB: Can't open
'./ibdata1' 2017-12-01 10:46:50 139842036406336 [ERROR] InnoDB: Could
not open or create the system tablespace. If you tried to add new data
files to the system tablespace, and it failed here, you should now edit
innodb_data_file_path in my.cnf back to what it was, and remove the new
ibdata files InnoDB created in this failed attempt. InnoDB only wrote
those files full of zeros, but did not yet use them in any way. But be
careful: do not remove old data files which contain your precious data!
2017-12-01 10:46:50 139842036406336 [ERROR] Plugin 'InnoDB' init
function returned error. 2017-12-01 10:46:50 139842036406336 [ERROR]
Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2017-12-01
10:46:50 139842036406336 [Warning] mysqld: GSSAPI plugin : default
principal 'mariadb/localhost@' not found in keytab 2017-12-01 10:46:50
139842036406336 [ERROR] mysqld: Server GSSAPI error (major 851968,
minor 
2529639093
) : gss_acquire_cred failed -Unspecified GSS failure.
Minor code may provide more information. Keytab FILE:/etc/krb5.keytab
is nonexistent or empty. 2017-12-01 10:46:50 139842036406336 [ERROR]
Plugin 'gssapi' init function returned error. 171201 10:46:50
server_audit: MariaDB Audit Plugin version 1.4.2 STARTED. 171201
10:46:50 server_audit: Query cache is enabled with the TABLE events.
Some table reads can be veiled.mysqld: Too many arguments (first extra
is 'restart'). 2017-12-01 10:46:50 139842036406336 [ERROR] Aborting
 
171201 10:46:50 server_audit: STOPPED
handlersocket: terminated
 
 

 
 
aggiungo :
 
service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled;
vendor preset: enabled) Active: active (running) since ven 2017-12-01
14:24:20 CET; 49min ago Process: 1595
ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited,
status=0/SUCCESS) Main PID: 1852 (mysqld) Status: "Taking your SQL
requests now..." CGroup: /system.slice/mysqld.service
           └─1852 /usr/sbin/mysqld
 
dic 01 14:24:20 localhost mysqld[1852]: 2017-12-01 14:24:20
139941059033152 [ERROR] mysqld: Server GSSAPI error (major 851968,
minor 
2529639093
) : g dic 01 14:24:20 localhost mysqld[1852]:
2017-12-01 14:24:20 139941059033152 [ERROR] Plugin 'gssapi' init
function returned error. dic 01 14:24:20 localhost mysqld[1852]: 171201
14:24:20 server_audit: MariaDB Audit Plugin version 1.4.2 STARTED. dic
01 14:24:20 localhost mysqld[1852]: 171201 14:24:20 server_audit: Query
cache is enabled with the TABLE events. Some table reads can be
veiled.2 dic 01 14:24:20 localhost mysqld[1852]: 2017-12-01 14:24:20
139941058411264 [Warning] Failed to load slave replication state from
table mysql.gtid_s dic 01 14:24:20 localhost mysqld[1852]: 2017-12-01
14:24:20 139941059033152 [Note] /usr/sbin/mysqld: ready for
connections. dic 01 14:24:20 localhost mysqld[1852]: Version:
'10.1.28-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0  Mageia
MariaDB Server dic 01 14:24:20 localhost systemd[1]: Started MySQL
database server. dic 01 14:29:21 localhost mysqld[1852]: 2017-12-01
14:29:21 139940344100608 [Note] feedback plugin: report to
'
https://mariadb.org/feedback_plugin/p
 dic 01 14:29:21 localhost
mysqld[1852]: 2017-12-01 14:29:21 139940344100608 [Note] feedback
plugin: server replied 'ok'
 
 
ma non trova la porta 3306
 
nmap localhost
 
Starting Nmap 7.40 ( 
https://nmap.org
 ) at 2017-12-01 15:04 CET
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00012s latency).
Other addresses for localhost (not scanned): ::1
Not shown: 993 closed ports
PORT     STATE SERVICE
21/tcp   open  ftp
80/tcp   open  http
111/tcp  open  rpcbind
631/tcp  open  ipp
783/tcp  open  spamassassin
1720/tcp open  h323q931
2049/tcp open  nfs
 
Nmap done: 1 IP address (1 host up) scanned in 0.05 seconds
 
 

 ma non trova la porta 3306
 
Beh, i log lo dicono: :D
 
localhost mysqld[1852]: Version:
'10.1.28-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 0
 
Sta ascoltando solo su unix socket (che PHP usa di default quando usi 
localhost come hostname, ma MySqlWorkbench no).
 
Bye.

 ha scritto:

si ma perchè non mi trova la porta mysql 3306?  mysqld è attivo , ho
provato anche a tirar giù i firewall, anche se da locale non ci
dovrebbe esser problemi.
 
enrico 
 

 
 
forse GSSAPI error ?
 

 > 
 
OK risolto ho commentato -skip-networking 
 
in /etc/my.cnf
 
riavviato e va.
 
rimane : GSSAPI error
 
enrico