mysql

I have a large website that receives a significant amount of traffic, and my friends have suggested that editing the MySQL configuration file can improve its performance. Can anyone share their experiences and insights into why and how editing the MySQL config file can benefit a high-traffic...

I'm exploring the differences between MariaDB and MySQL for my database needs. Beyond the initial fork from MySQL, what specific technical distinctions exist between the two? I'm particularly interested in aspects like performance optimizations, storage engines, compatibility, and community...

I only want to install these services for my VPS server to host my website. How can I do this in an easy way? please guide me.

In Plesk control panel, when creating a new mysql database, it has an option to allow mysql database to remotely, is that safe and secure for my website? or should I use local mysql connection only?

I see now some guys using MySQL 8.0, should I migrate from MariaDB to Mysql 8.0?

Fusion Arc Hosting - Web Hosting Tutorials ##################################################################################################### How to Download Backup of Home Directory, MySQL or E-mail Only? 1. Log into your cPanel account. 2. In the "Files" section, click on "Backup Wizard"...

I am using cpanel server, I am looking for a way to backup and restore websites including its files and databases only. Website are running on wordpress platform, I don't expect to use a plugin, i like using ways to work on hosting directly to backup files and mysql database in a fastest and...

When running these commands, you need to login to MySQL with the root account (MySQL root, not the root account that manages VPS) or an account with full permissions. All the actions I perform on VPS CentOS Log in to MySQL using the command: mysql -u root -p 1. Directory containing database On...

I have a dedicated server and running mysql on it, I heard that i shuold optimize my.cnf configuration for my dedicated server to get best performance for mysql, but what are configuration to put into my.cnf to obtain that? Can anyone suggest me?

I installed Mysql on my hosting but learned about SQL Server last time, can you tell me what are the differences between MySQL and SQL Server?

I have a VPS for manipulating with mysql databases, I would like to install Mysql on it. What command to install Mysql on CentOS 6 running on a VPS? Many thanks!

My web developer is asking which MySQL version I am using on my vps server and I checked with this command but he said it is not for my version of server, I tried to run this command but it is error Any suggestions?

I have a custom database and there is a word http:// that I want to change to https:// with a query in phpmyadmin or using CLI. What update command can I use to find and replace this text in all tables of my current database?

How can I export a Mysql database via SSH? I have too many my website databases and it consumed me more time when exporting databases from Phpmyadmin. I would like to know a way to export faster and download databases to my PC . Thanks in advance.

Hello, forum members ! Glad to keep you ''busy'' with another question, haha. I wanted to know can anyone tell me how to optimize mysql in cpanel ?

I want to install this programming language into my windows 10. Any easy tutorials ? Videos with step by step would be appriciated. Thank you

Hi: I'm following this manual to move the mysql directory https://forums.cpanel.net/threads/how-to-move-mysql-data-directory.110481/ but there is something wrong ln -s / home / mysql / var / lib / mysql ln: failed to create symbolic link '/ var / lib / mysql / mysql': File exists...

You happen to check your page one day and you see an error on your Wordpress site that says the following: "Your PHP installation appears to be missing the MySQL extension which is required by WordPress" There is 1 thing to check before searching all over the internet for a solution...

Does any one know of any tutorials or step by steps that can help on changing mysql hostname? I am searching for this information but the answers have seemed not to be in any detail at all. Thanks everyone if you read over my question and would be great if you have an answer for me :)

I have a small website running on a shared hosting plan and sometimes it is overloaded on CPU and Mysql. I checked cPanel and see I can kill all Mysql processes there but I am not sure it will solve my issue? Anyone tell me is there a way to kill all Mysql processes that safer and effective?