One of the daily tasks of a system administrator is upgrading services, applying patch packages, or adding some fancy new features. In early 2013, the latest MySQL 5.6 was released, aiming to deliver better performance and scalability. If you’re a bit interested, you can check out this article I wrote on How to Deb …
PHP frameworks are highly useful tools that help developers build clean, organized, and structured web applications while also accelerating the speed of creation and maintenance. Here, we will introduce the top 10 most popular PHP frameworks (in no particular order). Laravel
This …
1 MySQL Cluster Version Master-Slave Setup Guide MySQL master-slave servers can synchronize databases, tables, and table contents. You can also specify to synchronize only a certain database or table, or exclude specific databases or tables from synchronization. How synchronization works: Master-slave database synchronization primarily …
First, a disclaimer: generally, modifying MySQL passwords and granting privileges requires root access within MySQL.
Note: This procedure is performed at the Windows command prompt; phpMyAdmin is also applicable.
User: phplamp User database: phplampDB
1. Create a new user.
//Log in to MYSQL
@>mysql …
As a software developer or DBA, one essential part of the job is working with databases, such as MS SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, and so on. As we all know, MySQL is currently the most widely used and best free open-source database …
We have previously published three articles on Linux interview basics (Part 1, 2, and 3), which received positive feedback from readers. We also heard that some readers hoped this interactive learning method could be made more flexible. Action speaks louder than words, so we are now presenting you with 15 MySQL interview questionsQuestion 1: How do you …
MySQL is a powerful open-source database. With the rise of database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for tuning and optimizing your MySQL installation. Some tips are specific to particular environments, but these concepts …
Adding a User: (Note: Unlike the above, the following commands are executed in the MySQL environment, so each ends with a semicolon as the command terminator) Format: grant select on database.* to username@login_host identified by “password” First method: Add a …
Garbled characters appear when loading data with LOAD DATA INFILE. When using LOAD, the encoding of the database, table, and fields must match the file encoding. But if the database already has data and you don’t want to rebuild it, modifying the encoding via commands is a good choice. Below is the fix. I’ve tried modifying the character … in my.ini …
Cross-Domain and Cross-Server Session Solutions in PHP:
After researching online, I found that except for ASP.NET, all session persistence relies on the session ID. Opinions vary on where to store sessions, with the main options being: shared files, databases, and memcache. Therefore, the core issue revolves around the session i …
