Reset MySQL root password WITHOUT existing root password
Sometimes, you may need to reset MySQL root password without existing root password on your web hosting server. You can reset the password by following the below steps:
[1] Stop the MySQL service from the server.
[2] Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password.
[3] Connect to mysql server as the root user. You can connect with GUI tool or from SSH or command line.
[4] Update MySQL root password using the following query:
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
Flush the privileges using the following query:
FLUSH PRIVILEGES;
[5] Exit and restart the MySQL service.
For Linux servers, following are the complete steps with commands:
[1] Stop MySQL service:
# /etc/init.d/mysql stop
[2] Start MySQL with –skip-grant-tables:
# mysqld_safe --skip-grant-tables &
[3] Connect to MySQL server:
mysql -u root
[4] Set new MySQL root user password:
mysql> use mysql;
mysql> update user set password=PASSWORD("MyNewPass") where User='root';
mysql> flush privileges;
mysql> quit
[5] Stop and start MySQL service:
# /etc/init.d/mysql stop
# /etc/init.d/mysql start
That’s it. Now, you should be able to access MySQL server using the root password specified in steps 4.
Author: Kailash Aghera
AccuWebHosting.com Joins Hands With SmarterTools, Inc.
AccuWebHosting.com, a leading Windows VPS Hosting provider, is proud to announce its new partnership with software developer SmarterTools Inc.
The partnership will give AccuWebHosting.com’s Windows VPS and dedicated server customers a new and more improved range of services by providing the SmarterBundle at no additional cost.
“This partnership allows our company to offer SmarterTools’ world-class mail server solutions, powerful and feature-rich customer service helpdesk system, and comprehensive web log analytics software at no additional cost to our customers,” said Rahul C. Vaghasia, managing director for AccuWebHosting.com.
The SmarterBundle is valued at $800 and includes:
- SmarterMail 7.x (250 mailboxes) - SmarterMail 7.x delivers cutting edge features and performance. Along with superior stability, it also has the ability to protect mailboxes from 97% of spam out-of-the-box.
- SmarterStates 5.x (50 sites) – SmarterStats 5.x is a Web log analytics and SEO software solution that enables users to obtain detailed analysis of web traffic, visitors’ behavior, SEO marketing efforts, etc. This robust analytical tool is both user-friendly and efficient
- SmarterTrack 5.x (2 agents) – SmarterTrack 5.x is a powerful customer help desk system that is integrated with multiple service solutions in a single application.
“The SmarterTools software bundle not only provides a significant value and resource to our clients, but it also equips them, with what we clearly believe, is the very best technology and services available for this particular need,” Vaghasia added.
About AccuWebHosting.com
AccuWebHosting.com has been providing world class web hosting services to the global community for nearly the past decade. Priding ourselves in providing innovative technology coupled with top notch customer service, this credo has allowed not only us, but our customers to experience success and substantial growth.
About SmarterTools Inc.
Founded in 2003, SmarterTools Inc. is an information technology management software company based in Phoenix, Arizona. SmarterTools develops a Windows mail server, customer service software, and Web log analytics and SEO software that help companies communicate, measure, and support their worldwide business operations. Additional information about SmarterTools Inc. and the SmarterTools product line is available at www.smartertools.com.
Munin MySQL monitoring graph is not updating or blank
Munin is a monitoring tool used to monitor the performance of computers/servers, networks, SANs, applications, databases, weather measurements and other parameters. Munin remembers and records information it captured and presents them in graphs through a web interface. On cPanel/WHM server, you can easily install it from plugin section.
After successful installation, Munin will start colleting required data and will show you the graphs, including MySQL nodes such as MySQL throughputs, MySQL queries, MySQL Slow Queries, and MySQL threads. However, if you restart the server, Munin will fail to monitor MySQL nodes and it will stop showing graphs for MySQL.
The error is due to a bug in a Perl library Munin uses which causes $PATH variable to be lost, and then causes the plugin cannot find the mysqladmin program which it needs to retrieve the numbers to populate in the graphs. Uninstall and reinstall Munin Service Monitor may make it works again, however, a more permanent solution is to hardcode the path of the program, which will fix the problem. Following is the guideline to specify the path to mysqladmin to Munin.
Fix for Munin installed by cPanel/WHM
1. Find the path where mysqladmin is installed using one of the following commands:
which mysqladmin
type mysqladmin
locate mysqladmin
The above command will return a path to mysqladmin (i.e. /usr/bin/mysqladmin)
2. Edit Munin configuration file /etc/munin/plugin-conf.d/cpanel.conf and modify the [mysql*] as below:
[mysql*]
user root
group wheel
env.mysqladmin /usr/bin/mysqladmin
env.mysqlopts –defaults-extra-file=/root/.my.cnf
Ensure the env.mysqladmin value is path returned by step 1. Also ensure that /root/.my.cnf contains correct MySQL root password.
3. Restart Munin service:
/etc/init.d/munin-node restart
4. Wait a while for MySQL statistics to be gathered, and check the graphs again.
Fix for the host or server without cPanel Control Panel:
Simply add the “env.mysqladmin /usr/bin/mysqladmin” (ensure that the path is correct according to your system) to the /etc/munin/plugin-conf.d/munin-node file will do the trick.
Unlimited Disk Space and Unlimited Bandwidth hosting – is this scam?
Nowadays, many web hosting companies offer unlimited disk space and unlimited bandwidth in their shared hosting plans. Is it really possible to allocate unlimited disk space and bandwidth on a shared server? Absolutely NOT. If it is really possible then why there are no unlimited disk space and bandwidth plans for VPS hosting or Dedicated server?
Most of the web hosting companies put the restrictions in such a way; you can’t use the more disk space and bandwidth.
How to restrict the Disk space usage:
Almost every web hosting companies who are offering unlimited disk space set the restriction on inode usage. An inode is a data structure which contains information about a regular file, folder such as its size and owner. For more details on inode, refer our article “What is an inode?”. Generally, one file uses one inode. For example, if a web hosting company has set 50000 inode limits that mean you can keep maximum 50000 files/folders in your account. If you have many email accounts or images, you can easily exceed this limit. If your account exceeds their inode limit, your account will be suspended or terminated by them without availability of backup. Also, many web hosting companies put restriction on backup as well. If your account exceeds half of the allocated inode limit, it will be removed from their backup system.
How to restrict the Bandwidth usage:
Any web hosting companies can put the restriction on bandwidth usage using the following ways:
[1] Restrict total processes per user
It is quite possible to set this limit and if your account exceeds allowed process limit, the visitors will start receiving errors on your web site which is not at all good for your web site and you may lose the traffic.
[2] Throttle the bandwidth per Virtualhost and set allowed connections per IP address
There are many modules (i.e. mod_cband for Apache etc.) available to throttle the bandwidth usage per Virtualhost. It is also possible to set allowed connection per IP address.
Also, many web hosting companies do not allow large video files as well as flash files.
It is advisable to go through the terms or service before you sign up for such web hosting plans or you can go for limited disk space and bandwidth web hosting plans instead.
What is an inode?
An inode is a data structure which contains information about a regular file, folder such as its size and owner. The number of inodes you use represents the number of files/folders you have on your web hosting account. Many web hosting companies restrict the inode usage on the shared hosting server. Hence, even if they offer unlimited disk space, you cannot use it because of inode limit.
When a file is opened, the file’s inode is read by the kernel. If you have more files/folder in your account, the more inodes you use. Generally one file uses one inode.
As shared hosting customers, you may receive the notification regarding inode usage from your hosting provider. Generally the web site contents do not require more inodes. In most cases, catch-all account consumes more inode. You can delete/download emails from your catch-all email account to reduce the inode usage and if you do not require catch-all account, it is advisable to disable it. Also, if your account has many email accounts, it is advisable to download the emails via email client software viz. Outlook, Thunderbird etc.
You must use the Role Management Tool to install or configure Microsoft .NET Framework 3.5
If you are using Windows 2008 R2 operating system, you may receive the following error while installing Visual Studio 2008 or .NET Framework on your server:
You must use the Role Management Tool to install or configure Microsoft .NET Framework 3.5
 |
| This is because Windows 2008 R2 comes with pre-installed .Net Framework 3.5.1. You just require to enable this feature from “Server Manager”. |
Using Role management tool, you can easily enable .Net 3.5 framework on your web hosting server or development server.
Affordable Windows Hosting just $4 + FREE Domain Registration + ASP.Net Hosting
WHM error while adding IP address – Skipping xxx.xxx.xxx.xxx already added
Recently, I faced a problem to add an IP address from WHM. I received the following error while adding an IP address:
All Requested Ips were already active
System has 0 free ips.
Skipping xxx.xxx.xxx.xxx .. already added
But when I checked in IP Functions -> Show/Edit Reserved IPs, it was not listed in it. To resolve this I followed the below steps:
[1] Checked chkconfig for ipaliases:
I checked chkconfig for ipaliases and it was on for 2, 3, 4, 5.
chkconfig –list ipaliases
[2] Restarted ipaliases service:
After checking chkconfig, I restarted ipaliases service using following command:
/etc/init.d/ipaliases restart
This did the trick and all IP addresses were displaying again on Show/Edit Reserved IPs page.
- Kailash Aghera
-
Recommended Host
-
