Cannot log in mariaDB

[taroumaru]

My device is WZR-900DHP2 OpenWrt19.07.3
I installed mariaDB server but I can build mariaDB server but I cannot log in to databases. After socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution
After that, Everything is stuck. so What should I do?

root@OpenWrt:~# mysqld -u mariadb
2020-05-31 13:11:53 3069322592 [Note] mysqld (mysqld 10.2.32-MariaDB) starting as process 1838 ...
2020-05-31 13:11:53 3069322592 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-31 13:11:53 3069322592 [Note] InnoDB: Uses event mutexes
2020-05-31 13:11:53 3069322592 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-31 13:11:53 3069322592 [Note] InnoDB: Number of pools: 1
2020-05-31 13:11:53 3069322592 [Note] InnoDB: Using generic crc32 instructions
2020-05-31 13:11:53 3069322592 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-05-31 13:11:54 3069322592 [Note] InnoDB: Completed initialization of bufferpool
2020-05-31 13:11:54 2848718180 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpr iority().
2020-05-31 13:11:54 3069322592 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-31 13:11:55 3069322592 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-05-31 13:11:55 3069322592 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-05-31 13:11:55 3069322592 [Note] InnoDB: Setting file './ibtmp1' size to 12MB. Physically writing the file full; Please wait ...
2020-05-31 13:11:55 3069322592 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-05-31 13:11:55 3069322592 [Note] InnoDB: Waiting for purge to start
2020-05-31 13:11:55 3069322592 [Note] InnoDB: 5.7.30 started; log sequence number 1616125
2020-05-31 13:11:55 2852433252 [Note] InnoDB: Loading buffer pool(s) from /mnt/sda1/mysql/ib_buffer_pool
2020-05-31 13:11:55 2852433252 [Note] InnoDB: Buffer pool(s) load completed at 200531 13:11:55
2020-05-31 13:11:55 3069322592 [Note] Server socket created on IP: '127.0.0.1'.
2020-05-31 13:11:55 3069322592 [Note] Reading of all Master_info entries succeeded
2020-05-31 13:11:55 3069322592 [Note] Added new Master_info '' to hash table
2020-05-31 13:11:55 3069322592 [Note] mysqld: ready for connections.
Version: '10.2.32-MariaDB' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Source distribution

[micmac1]

I don't think there's a problem here. You just started the server directly and it doesn't drop into the background.

Login with a second shell and kill the server. Then just use the init script to start the server.

[micmac1]

You can use logread and it'll show you the same output after the init script starts your server btw.

[taroumaru]

Thank you for your reply. I changed like this. but nothing changed.
mysql-server in LEDE17.01.7 has no problem.

I think mariadb-server have somethig wrong.

/etc/init.d/mysqld start

config mysqld 'general'
option enabled '1'

[ulmwind]

OK, so 'mysql' in first case, and 'mysqld' in second.

[taroumaru]

Mariadb-server use mysqld latest version same as mysql 5.7

Mysql-server use mysql version 5.1 very old.

Mariadb-server is used instead of mysql-server since OpenWrt 18.06
I know the reason why they dont accept root login .
Just because they automatically set random password after install since mariadb-server.

Someone tryed to use mariaDB-server and gave up using.

[eduperez]

I am currently using mariaDB on OpenWrt, and have no issues here. See how @ulmwind explained the differences between what you do in one case and what you do in the other.

[Grommish]

For testing, just add a & to the end of the command to drop it to the background. mysqld -u root &

[taroumaru]

I appreciate your advise.
I can login now just because I didint install mariadb-client.
its need client. Thank you so much.
Everything is going well.
Sorry for stupid question

[taroumaru]

Solved. I close this topic