If you find an error such as shown below
=================
Connection refused_ 421 4.3.0 deliver: couldn't connect to lmtpd_ )
=================
fix is shown below
While accessing web configured with mysql 8 and php and you see the following error: CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client OR PHP Fatal error: Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] It maybe due to PHP devs might have not implemented the MySQL's 8.0 connection protocol ( auth with caching_sha2_password ) within the newer PHP versions. If you want to use mysql >= 8 and you dont care about caching_sha2_password, If you are running a fresh install of mysql 8, just select the second option as shown in the image. Otherwise, you need to configure MySQL 8.0 to run in mysql_native_password mode. As it can't configured in my.cnf, change the user profile as:- ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUs...
In linux we normally use the option -maxdepth with the find command to report all files and links in the currect directory, not recursively for example:- find /some/directory/ -maxdepth 1 -type f -name *.log But when we use the same in Oralce Solaris OS, the command will give error as maxdepth is not an option recogonized in the system. We can replace it with -prone and the syntax is as follows:- find /some/directory/* -prune -type f -name *.log this should also work with IBM-AIX OS
Backup and restore database using linux command mysqldumb is the simplest and the easier method. For taking backup of all databases:- mysqldump -u root -p --all-databases > dumb.sql For Restoring the databases:- mysql -u root -p < dumb.sql Its that easy.
Comments
Post a Comment