[ERROR] mysqld: Can‘t open shared library ‘/usr/local/mysql/lib/plugin/validate_password.so‘ (errno:
一 問題描述
使用二進位制包安裝MariaDB後，啟動資料庫報錯：
[ERROR] mysqld: Can't open shared library '/usr/local/mysql/lib/plugin/validate_password.so' (errno: 0, cannot open shared object file: No such file or directory)
[ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'validate-password=OFF'
二 出錯原因
該伺服器之前安裝過Mysql，貌似和之前的Mysql衝突了。
三 解決辦法
解除安裝之前的Mysql:
① 關閉Mysql
② 刪除資料目錄
③ 解除安裝mysql包
示例：
rpm -qa | grep mysql
rpm -e 上述名稱查詢出來的mysql包
相關文章
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- Can't open file: (errno: 24)
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- docker mysql mysqld: Error on realpath() on ‘/var/lib/mysql-files‘ No such file or directoryDockerMySqlError
- Can't debug c++ project because unable to static library start program *.libC++Project
- code EACCESnpm ERR! syscall renamenpm ERR! path /usr/local/bin/webpack errno -13NPMWeb
- mysqld: Can‘t create directory ‘E:\Software\mysql-5.7.24-winx64\data\‘ (Errcode: 2 - NoMySql
- Warning:The /usr/local/mysql/data directory is not owned by the 'mysql' or '_mysql'MySql
- -bash: /usr/local/bin/pod: /System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/bin/ruby: b...Framework
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- 本地報錯：Mac PHP7.1 dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.63.dylibMacPHPUI
- Error while loading shared libraries: libreadline.so.7: cannot open shared objecErrorWhileOBJ
- error while loading shared libraries: libgsl.so.27: cannot open shared objectErrorWhileObject
- FILESTREAM feature can't be enabled if you use cluster shared volumes
- Php cli模式下執行報錯/usr/bin/php: /usr/local/lib/libxml2.so.2: no version information available (required by /usr/bin/php)PHP模式XMLORMAIUI
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- brew update /usr/local is not writable
- ./XXX.XX: error while loading shared libraries: libGLEW.so.2.1: cannot open shared object file: NoErrorWhileObject
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- /usr/lib/wsl/lib/libcuda.so.1 is not a symbolic linkSymbol
- FileZilla：425 Can't open data connection for transfer of解決辦法
- rpm: error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such fi...ErrorWhileGCObject
- Fatal error: can't check configuration file '/home/watt/proxy/dError
- 解決ERROR 1231 (42000): Variable 'time_zone' can'tError
- DZ論壇MySQL Query Error Errno:1046錯誤MySqlError
- 清理挖礦程式後執行任何命令報/usr/local/lib/libprocesshider.so解決方法IDE
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- error while loading shared libraries: libpython3.7m（2.7）.so.1.0: cannot open shared object file: NErrorWhilePythonObject
- GTID複製報錯處理：Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython
- MySQL 啟動報錯 error while loading shared librariesMySqlErrorWhile
- How to compile libusb as shared/static libraryCompile
- /bin、/sbin、/usr/bin、/usr/sbin、/usr/local/sbin放置可執行檔案的區別
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- ORA-15180: could not open dynamic library ASM LibraryASM
- chown: /usr/local: Operation not permitted問題解決MIT
- MYSQL報1022錯誤：Can't write;duplicate key in table '.....'MySql