Centos7 installation MySQL is stuck. After typing: sudo systemctl start mysqld, the cursor stops there.

referenced tutorials:
https://www.digitalocean.com/.
https://linode.com/docs/datab.

Environment: cetnos7,openresty, has been installed and php7,info.php also appears normal. Previously installed mariadb, and uninstalled, now install mysql5.5

the process of executing a command:

< H1 > sudo yum install mysql-server < / H1 >

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile

  • base: mirror.atlanticmetro.net
  • epel: fedora-epel.mirrors.tds.net
  • extras: mirror.atlanticmetro.net
  • ius: ius.mirror.constant.com
  • remi-php70: mirror.team-cymru.org
  • remi-php71: mirror.team-cymru.org
  • remi-php72: mirror.team-cymru.org
  • remi-safe: mirror.team-cymru.org
  • updates: mirror.atlanticmetro.net
  • webtatic: us-east.repo.webtatic.com

Package mysql-community-server-5.5.59-2.el7.x86_64 already installed and latest version
Nothing to do

< H1 > sudo systemctl start mysqld < / H1 >

(after entering this command, the cursor is stuck here)

could you tell me the specific solution?

Screenshot of

/ var/log/mysqld.log:

clipboard.png

Screenshot of

/ etc/my.cnf configuration:
https://i.imgur.com/e4TYUED.png

Mar.03,2021

/ usr/bin/mysql_secure_installation
follow the prompts to enter enter
and then enter 4 y
and then sudo systemctl status mysqld

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1be9bc7-31998.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1be9bc7-31998.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?