Configurer selinux et Mysql sur une base redhat

Au passage les commandes pour un changement de la basedir et résolution du problème de read/write dans mysql.log lorsque selinux est mal configuré Tout d’abord avoir les outils indispensables: Vérifier que vous avez tout ce qu’il faut: rpm -q checkpolicy libselinux libselinux-python libselinux-utils libsemanage libsepol policycoreutils selinux-policy selinux-policy-minimum selinux-policy-mls selinux-policy-strict selinux-policy-targeted setroubleshoot setroubleshoot-server setroubleshoot-plugins setools […]

changer le mot de passe root d un server mysql

‘service mysql’ stop wait until MySQL shuts down. Then run mysqld_safe –skip-grant-tables & then you will be able to login as root with no assword. mysql’ ‘-uroot mysql In MySQL command line prompt issue the following command: UPDATE user SET password=PASSWORD(abcd ») WHERE ser= »root »;FLUSH’ ‘PRIVILEGES;EXIT /etc/init.d/mysqld restart At this time your root password is reset to […]

Lost my mysql root password… not such a pain…

Stop Mysql service mysql stop wait until MySQL shuts down. Then run mysqld_safe –skip-grant-tables & then you will be able to login as root with no assword. mysql -u root mysql In MySQL command line prompt issue the following command: UPDATE user SET password=PASSWORD(‘abcd’) WHERE user=`root`@`localhost`; FLUSH PRIVILEGES; EXIT Restart Mysql: /etc/init.d/mysqld restart Now your […]