BLACK FRIDAY SALE IS LIVE !!!!!

mysql server

Mysql server through web using phpmydmin
Blog
Sourav AJ

How to access a Remote MySQL Server through Web using phpMyAdmin

Consider a domain “example.com” hosted on server 172.xxx.xxx.31 with the document root /var/www/example.com/public_html/ and a MySQL server on another server with IP 80.xxx.xxx.123. There are various options for remotely accessing the MySQL server via a web browser. Let’s look at how it can be done with phpMyAdmin. First, we will create a sub directory phpMyAdmin inside the doc root of the domain example.com. Change the current directory to phpMyAdmin Download the latest version of phpMyAdmin

Read More »

How to solve: ERROR 1130 (HY000): Host ’90.xxx.xxx.101′ is not allowed to connect to this MySQL server

Scenario : Getting error 1130 when trying to remotely connect MySQL server with ip address 172.xxx.201.xxx from my server 90.xxx.xxx.101 using the Database user ‘test_123’.  To resolve the above error, first log into the MySQL server in 172.xxx.201.xxx and search for the user test_123, to ensure whether it exists on the server. The above query is used for checking whether the user exists or not and if so, from which host or IP address they

Read More »

Indexing JSON Data in MySQL

Putting away JSON in a social data set is something designers have accomplished for a long while. There are different motivations behind why you would need to store JSON in a data set table – client inclinations and design information are two genuine models. The JSON Information Type was acquainted with MySQL in adaptation 5.7.8. This information type permits us to store substantial JSON in a data set section and run questions in view of

Read More »

How to Create User in MySQL and Grant Permission

MySQL is an open-source database management system for storing, organising, and retrieving data. It includes a number of options for granting individual users access within tables and databases. On our server management plan, our experts will cover MySQL setup, optimisation and database migrations. Create User in MySQL Login to MySQL server with below command Now, create the user At this time, newuser does not have any access to the databases. In fact, newuser will be

Read More »

How to Apply Configuration Fails in Nagios Server

Before we drive to the solution part, let’s have a glance at the reason that cause an error.  This Blog will drive you to how to apply configuration fails in the Nagios server. If you need any assistance to fix the error, you can take our technical team support to be done on your behalf.  Let’s have a look at the cause of the error. An error message will be displayed on the screen when apply configuration

Read More »

How to fix Event Data getting Stale in Nagios

  In some Nagios version, our clients using Nagios reported a bug relating to event data. However, this bug has been patched and will be available in releases later. If you still experiencing the error and /or the Nagios services taking a long time to start that may be due to corruption in the MySQL table. Our technical team support will fix event data getting stale in Nagios under our server management plan. You can also

Read More »

Installing NDOUtils in Ubuntu

  Often, get reports that Nagios core is not working due to an outdated version of NDOUtils From this blog, you will get an apparent view regarding the installation and configuration of NDOUtils in Ubuntu as a part of our server management plan. You can also take assistance from our technical team support 24/7 for further Migration and configuration. Follow the steps to install NDOUtils in Ubuntu Steps to install NDOUtils in Ubuntu First is installing

Read More »

Resetting the WordPress admin password using Linux or Unix MySQL CLI

  Sometimes, the WordPress user forgets there login credentials especially the password. The WordPress user can change their password easily via the “Lost password”. You can also reset the new password by creating the MD5 Hash. On our server management plans, our experts will help you in resetting the WordPress admin password using the Linux or Unix MySQL CLI. You can check with our team at any time for emergency support. Follow the steps to reset the

Read More »

How to Reset MySQL root password in Centos 7

MySQL Is an open-source Relational Database Management System (RDMS). It uses tables, triggers, variables, views, etc. MariaDB is a fork of MySQL. The database structures and indexes of MariaDB are same as the MySQL. This blog covers the steps to reset MySQL root password without any data loss. Here in Skynats, we had done so many mysql root password reset without any data losses under our server management service. Reset root password in Safe Mode

Read More »

MySQL Server Optimization

Mysql is a superior open source database. With immense and intense database-driven applications people are pushing Mysql beyond its limits. Running MySQL at desirable settings for specific resources helps to handle large server loads and prevents server slowdown. In case you want your server to perform optimally, the best solution is to get tons of memory and big, rapid drives. When we are enlisted for a MySQL execution review, we are relied upon to survey the MySQL setup and to propose

Read More »

FREE SERVER AUDITING

Get Auditing Report of Your Server for FREE!!