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 …
1. Use a cookie to store the session_id(); Example: PHP code in Domain One: <?phpsession_start();setcookie("session_id",session_id(),time()+3600*24*365*10,"/",".session.com"); $_SESSION['user_name'] = 'Liangshan …
1. grant all on db_name.* to user_name@’localhost’ identified by ‘password’; ——This also allows you to set the password in the same step.
2. flush privileges; ——Don’t forget to flush privileges after granting …
What should you do if you accidentally perform a wrong operation on a database and don鈥檛 have a timely backup? This is probably a common problem that many coders often encounter.
Today, I accidentally deleted a database, but the last backup was from a week ago. The only way to resolve this is through mysqlbinl …
