Environment
CDH 5
MySQL 5.7.30
check the manual that corresponds to your MySQL server version for the right synta to use near '@ default character
set utf8 at line 1
reason
For the problem of script execution mode, – P does not write a password after it. Execute it directly, and then enter the password. The result returns successful
/usr/share/cmf/schema/scm_prepare_database.sh mysql -h Database_ip -u username -p --scm-host cdhip scm scm scm
Read More:
- Zabbix import MySQL database error ERROR 1046 (3D000) at line 1: No database selected
- C# System.Data.SQLite.SQLiteException:“SQL logic error or missing database no such table: XX”
- Database mirroring connection error 4’An error occurred while receiving data: ‘10054(An existing connection was forcibly closed by the remote host.)
- [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
- [Linux Docker Mirror] MYSQL Run sql Script Error: Failed to open file ‘/home/mydatabase.sql‘, error: 2
- Oracle Database AWR error: ORA-06502 [How to Solve]
- [Solved] C# connecting to MySQL database reports an error
- [Solved] Connections could not be acquired from the underlying database
- [Solved] Error 1044: Access denied for user ‘syz-remote‘@‘%‘ to database ‘webapp‘
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- [Solved] MySQL Execute update error: error code: 1175
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [How to Fix] Database can’t open file (errno:24)
- [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata
- Linux Error: [ERROR] –initialize specified but the data directory has files in it. Aborting.
- Mysql Script Error Code: 1136. Column count doesn’t match value count at row 1
- [SQL ERROR] SQL Error: could not execute statement & query did not return a unique result: 2； nested excepti
- ERROR 1265 (01000): Data truncated for column ‘ENABLED’ at row 7
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used by doubl