buy tb500

Archive for November, 2013

is deprecated. mysql is now updated by the rpm.versions system when you run upcp

Sunday, November 17th, 2013

is deprecated. mysql is now updated by the rpm.versions system when you run upcp

the solutions

–It’s generally recommended to troubleshoot an issue before reinstalling MySQL to resolve –it. However, if necessary, you can remove the existing MySQL RPMs and then run the –following command:

/usr/local/cpanel/scripts/check_cpanel_rpms –fix

–It’s also a good idea to backup your MySQL data before reinstalling it:

cp -Rf /var/lib/mysql /var/lib/mysql-backup

–You can remove the backed up directory after you ensure MySQL was reinstalled –successfully.

–remove the existing MySQL RPMs

–You can run the following command to get a list of the MySQL RPMs installed on your –system:

rpm -qa|grep MySQL

–Then, you can remove the RPMs that start with the version of your MySQL. For instance, –if you have MySQL 5.5 installed, you would run a command such as this for each MySQL55 –RPM:

rpm -e MySQL55-server-5.5.32-1.cp1136.x86_64

thanks all, done, test it and working fine, fixed the issue

reference

http://forums.cpanel.net/f354/scripts-mysqlup-deprecated-mysql-now-updated-rpm-versions-system-when-you-run-upcp-356561.html

create list of emails using command prompt – plesk windows server

Saturday, November 16th, 2013

The below command to create emails in plesk using command line… the command will help if you have many emails to create

C:\Program Files (x86)\Parallels\Plesk\admin\bin>for /f “tokens=1,2” %i in (c:\m.txt) do mail.exe –create %i@lbs.com.my -mailbox true -passwd %j

need to put the file email.txt in c:\ driver and run the command in %plesk_bin% direcotry, must be inside the directory

thank you.

How do I enable remote access to MySQL database server?

Saturday, November 16th, 2013

* bind-address : local IP address to bind to. If you wish mysql listen on all IPs, don’t use this option.

For example if you want to allow access to database called ‘foo’ for user ‘bar’ and remote IP 192.168.0.1 then you need to type following commands at “mysql>” prompt:

mysql> GRANT ALL ON foo.* TO bar@’192.168.0.1′ IDENTIFIED BY ‘PASSWORD’;
mysql> REVOKE GRANT OPTION ON foo.* FROM bar@’192.168.0.1′;

references

http://kb.parallels.com/en/1134