Please enable JavaScript.
Coggle requires JavaScript to display documents.
DirectAdmin (Mysql (Change MariaDB to MySQL (find maria & stop mysql…
DirectAdmin
-
-
-
Remove Repo
- remove from /etc/yum.repos.d/
- yum erase
yum list installed | grep mysql
- yum clean all
Change MariaDB to MySQL
-
- find: yum list installed mariadb*
- disable: sudo yum-config-manager --disable mariadb
- remove: sudo yum remove MariaDB-common
*error: remove all except MariaDB-Server
$yum erase MariabDB*
su -c 'yum clean all && rpm --rebuilddb'
su -c 'package-cleanup --problems'
su -c 'yum erase MariaDB*'
$'yum --setopt=tsflags=noscripts remove MariaDB*'
$'rpm -e --noscripts MariaDB*'
ref link
-
-
Issue
-
origin:
mv /usr/bin/mysql /usr/bin/mysql_backup
cd /usr/local/directadmin/custombuild
./build set mysql_inst mysql
./build mysql
[change] mv => rm /usr/bin/mysql*
-
-
-
Password
Reset MySQL's root pw
/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -uroot -p ( hit enter, without any password)
use mysql
UPDATE mysql.user SET password=PASSWORD('your_new_password') WHERE user='root';
FLUSH PRIVILEGES;
quit
/etc/init.d/mysqld restart
-
-
-
-
-
-
-
-
-
-
-
-
-