If you want to install PHP-Mssql module using yum on your
centos server then just execute the below commands :
[email protected][#] yum install php-mssql
This will install PHP-Mssql on your server,
but for the changes to reflect restart the apache service on the server
[email protected][#] /etc/init.d/httpd restart
That’s all easy isn’t it.
If you have disabled the option :"The database prefix option has been
disabled". It cannot be enabled through the WHM and should not be
re-enabled if any databases or database users have been created
with database prefixing disabled." from WHM and want's to
re-enabled it but does not find any option as to how to
re-enable that option don't panic.
Follow the below steps to re-enable that option :
1> Login to Server via SSH as a root user
2> open this file : /var/cpanel/cpanel.config in you favorite editor
[email protected][#] vi /var/cpanel/cpanel.config
and then search for the line : database_prefix=0
and replace it with database_prefix=1
save and quit.
restart the cpanel service
[email protected][#] /etc/init.d/cpanel restart
That’s all you are done.
If you get the above error then it means that there is some problem with the mysql privileges which you can easily fix by running the below commands from shell :
[email protected][#] vi /etc/my.cnf
and add this line :
save and quit.
Restart the mysql service on the server.
[email protected][#] /etc/init.d/mysql restart
this allows you to login back to plesk
and now to fix the mysql privileges execute the below command:
[email protected][#] mysql_fix_privilege_tables --user=admin --password='yourpassword' --verbose
now restart mysql service for the final time
That's all you should now be easily able to change the
Plesk admin password from the Control panel.