Explore MySQL on Experts Exchange

Expert Solutions for Your Tech Problems

MySQLMySQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired...

Read more
  • 49K Content
  • 9.4K Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

Databases User Registration

16

When my database user logs into their account, they are told that their account is not activated.

Article

3 Ways to Speed Up MySQL

35

There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these

Video
Post
Troubleshooting Solution

Mariadb blew up... why? What is causing this?

207

We've been chasing a mariadb problem for months and eliminated all we could to the point of staring

Troubleshooting Solution

Website hangs on Mysql connection

33

Hi Experts,


A clients website hangs randomly for all users. Users seem to be stuck at

Article

PHP Client Registration, Login, Logout and Easy Access Control

47
Foreword
In the years since this article was written, numerous hacking attacks have targeted…
Advice Solution

sql grid bulk update

25

hi


i need to handle bulk updates affecting multiple rows and different data for each row.

the data

Troubleshooting Solution

Where to store the encryption key for PHP scripts (and MySQL database)?

byZack
27

Hi Everyone,


   I'm writing a PHP app where certain fields in a row of the MySQL database are

Troubleshooting Solution

Expand SQL statement to include the datatype with name of the field

46

I am looking to expand this query below so that each field returned has its datatype next to it,

Troubleshooting Solution

curl mysql php - entry into mysqk fails

180
Why in the world is this not working? I am trying to insert the following variables into mysql via …
Troubleshooting Solution

SQL statement needed for MariaDB

36

I have a SQL query console window opened within my IntelliJ IDE and am able to type select and other

Troubleshooting Solution

Create a SQL Database

141
Hi all, I am sorry for this but I have been out of town visiting a deathly ill family member and am …
Article

Handling Date and Time in PHP and MySQL - Procedural Version

8

Introduction

This article is very old, and while most of its principles are sound, PHP programming

Troubleshooting Solution

Find the location and size of my MariaDB database on a Centos server

20

My EC2 server is using a Centos-like distribution. Is there a single BASH command that I can type to

Troubleshooting Solution

Query two MySql tables to find out all records with last_update_time OLDER than 7 days

15

I want to do a MySql query of two tables to find out all records with last_update_time OLDER than 7

Video
Article
Troubleshooting Solution

Why Does Mysql Keep Increasing Memory Usage?

111
My site went down due to Maria DB increasing in memory usage.  I am running atop and went through …
Troubleshooting Solution

Need to create csv file and email it from a cron job

102
Hi,
I need a cron job that will export some MySQL data to CSV, then send the result by email.
by …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more