MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

0
votes
0answers
7 views

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: ...
2
votes
0answers
6 views

odbc error connecting mysql: “sql server does not exist or access denied”

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
0
votes
1answer
9 views

how to save mysql dumps for N days?

Is there any best practice for saving mysql-dumps daily backups for 30 days and then delete them, without writing scripts that checks date and delete? maybe a builtin tool?
0
votes
0answers
6 views

can't log into phpmyadmin from browser

It gives the error This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser ...
0
votes
0answers
19 views

Wrong IP address present when connecting from localhost to localhost

I have a Linux server with Ubuntu installed on it. When I connecting to some service (MySQL, apache, icecast for example) from the same machine at address 127.0.0.1, they all show that I connected ...
1
vote
1answer
18 views

MySQL connection works on CLI, but not on Workbench

I can connect to a running, remote MySQL database server just fine if I use the command line. I need to remotely login on a remote machine using SSH, and from there perform the MySQL login command. ...
21
votes
8answers
3k views

Can a massive MySQL data import on an SSD damage it?

I have to import quite a lot of data (~100 million rows, ~100 times) into a MySQL database. Currently, it is stored on my hard disk drive, and the bottleneck of my import seems to be the hard disk ...
1
vote
1answer
12 views

How to confirm apt-get confirmation during mysql-server installation

I am trying to write bash script that will install mysql-server-5.6 I want to ask user for password and then I will use it during installation mysql-server and some other configuration. But my script ...
0
votes
0answers
10 views

Ticket-like table and growing database

I manage a MySQL database through phpMyAdmin. I have a table for cinema cupouns tickets. I upload a bunch of tickets, and then I assign tickets to users. Each ticket contains, id -> ...
1
vote
1answer
16 views

MySql service start fails without anything meaningful (CentOS 7)

[root@myserver my.cnf.d]# service mysql start Starting MySQL. ERROR! And this is all I get. I tried checking the logs but couldn't find anything related to this. The database worked perfectly fine ...
0
votes
1answer
21 views

Allowing remote connections for MySQL on Ubuntu 14

I am trying to connect to MySQL using a program called Heidi, I want to use this instead of phpmyadmin. It's better than phpmyadmin and I figured it would be more secure than going to ...
-1
votes
1answer
26 views

Incorrect syntax near 'AUTO_INCREMENT' [closed]

I get an error on AUTO_INCREMENT while creating the following table. Please help. CREATE TABLE Invoice( Invoice_No INT NOT NULL AUTO_INCREMENT, Order_ID INT NOT NULL, TotalPrice VARCHAR(30) NOT ...
0
votes
1answer
18 views

Google Maps API and bandwidth consumption

I have a site that uses 2 Google Maps APIs. https://maps.googleapis.com/maps/api/js and https://maps.googleapis.com/maps/api/geocode/json This "mapper" site communicates with 2 Google Maps APIs, ...
0
votes
1answer
10 views

Sub-domains keeps redirecting me to Main web-site

I have just upgraded my version of LAMP Environment. Rest all the things are working fine but with Sub-domains i have a challenge. I have a Main website abc.biz and 5 to 6 sub-domains with it as ...
1
vote
1answer
18 views

Unix permissions error when working with symbolic link and MySQL installation

I'm working to install MySQL on one of our servers. I'm the ec2-user, and I'm attempting to install in the ec2-user home directory, but allowing access to the directory to the mysql user. However, ...
-1
votes
0answers
9 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
0
votes
0answers
12 views

Exporting / Importing MySQL from/to different character sets

It's fairly straightforward. I have a db running tables with DEFAULT CHARSET=utf8; The collation is set to utf8_general_ci. Everything is working fine. The application that uses this database saves ...
0
votes
0answers
6 views

multiple database syncing in different locations in MYSQL at periodic timings [migrated]

i have a system at head office with MySQL installed. i have client machines at different locations. i need to sync all the database for example once a customer detail is entered in one client it has ...
0
votes
0answers
5 views

Can't change system variables from config files on MariaDB/MySQL on Linux

I want to change two system variables on my MySQL testing server, namely collation_server and collation_database from latin1_swedish_ci to utf8_general_ci, because its annoying that everytime I create ...
0
votes
0answers
11 views

Moodle downgradedcore error

I have a moodle installed on a VPS. MySQL server has stopped, so I have made a power cycle on my server. After restart I have got the following error on admin login: ERROR!!! The code you are using ...
0
votes
0answers
18 views

Starting MySQL database server: mysqldinstall: invalid user `mysql'

i have a problem with mysql on my Raspberry Pi running Linux raspberrypi 3.18.7+ #755 PREEMPT Thu Feb 12 17:14:31 GMT 2015 armv6l GNU/Linux. This is error I have when I run sudo service mysql start ...
0
votes
0answers
21 views

Sending an email using Google's SMTP server [migrated]

I'm having a trouble sending an email using Google's SMTP Server. I've looked for a solution but i have not found one. So here's the code. import javax.mail.Message; import ...
-2
votes
0answers
31 views

Unusual sudden high CPU load from Mysql - above 900%

I have been experiencing high CPU load, caused by Mysql v5.6.23. I have 12 cores CPU with 64GB memory on Centos 6.6 Cloudlinux. On checking on processlist showed mostly reads and did not appear to ...
0
votes
0answers
13 views

Webmatrix 3 - MySQL

Ive got a newly formatted computer (Win7x64). I've installed Webmatrix 3 fine. When i start something from the gallery that needs a db for php, say joomla, wp or just a php app, it gets to step 4 for ...
0
votes
1answer
33 views

MYSQL UTF8 characters encoding issue [closed]

I have a contact form for a Turkish website and when users enter Turkish characters such as "ş" "ç" or "ğ" I am getting whole bunch of symbols in my DB registry (PHP My Admin) My current config is ...
0
votes
1answer
9 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
0answers
20 views

Can't access mysql db on Azure Ubuntu VM

Trying to access the DB from a remote system - tried with a Wordpress install and get "erro trying to connect to database" and also tried just using a test php file and get a white screen - no errors ...
0
votes
0answers
34 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Our MySQL server keeps giving us this message. And it's a constant thing, I will restart it then 5 minutes, or 30 minutes later I will just get this error again. I've been googling like crazy to fix ...
0
votes
0answers
14 views

phpmyadmin wordpress export only showing postmeta columns

Trying to export - and the import - a Wordpress MySQL DB using phpmyadmin. I've done this quit a bit in the past and I'm completely perplexed at this point! I have a fairly standard Wordpress DB with ...
0
votes
0answers
12 views

OSX: mysqladmin create database: connect to server at 'localhost' failed

I'm trying to create database in mySQL on OSX using the command line: $ mysqladmin create database Getting: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user ...
0
votes
1answer
9 views

Linux. MySQL command-line client. Set '--sigint-ignore' option forever

I think ctrl+c is required sometimes but I can't remember I needed it. Sometimes I'm trying to copy output text by pressing that "hotkey" automatically and losing db connection instead. It is very ...
-1
votes
0answers
12 views

MS Publisher has no data via ODBC [closed]

I am using a MySQL DB on a Server. I have MySQL ODBC driver installed and MS Access is able to link Server Tables and shows data. Publisher can't. I can configure the connection, but there is no data. ...
0
votes
0answers
40 views

Extracting HTML from Excel to enter in MySQL/Wordpress site

I have a WordPress site and an Excel document. I'm not familiar with Excel formulas so forgive me. The document contains a lot of names, email addresses and telephone numbers. I want to create a ...
0
votes
0answers
27 views

MySQL installed on debian (raspbian), is running in background, but “mysql: command not found”

I have a linux server running at home on a Banana Pi (very similar to a Raspberry Pi) with a few small websites and databases. Specifically; $ cat /etc/*-release PRETTY_NAME="Raspbian GNU/Linux 7 ...
0
votes
0answers
10 views

PC gets stuck when start the MySQL Workbench

I'm using mySql workbench 6.2CE and I was using it for more than 3 months. Suddenly when I start it few days back, it opened the workbench but my pc got stuck (Windows 8.1). Ans still the problem is ...
0
votes
0answers
23 views

XAMPP seems to be calling the server twice on every request

I have an issue for a site I'm developing. There's a function on this site that has been run to create a team, and it's been working fine for years. After installing XAMPP on a fresh computer, the ...
1
vote
1answer
26 views

How to find out the user who changed the MySQL root password?

On my CentOS testing server, someone has changed the MySQL root password. Is there any way to find out, who changed the password and when?
0
votes
0answers
17 views

Receiving authentication failed error while running sonar with Mysql

Receiving authentication failed error while running sonar (3.7.3) with Mysql.I am able to run sonar using h2 database of the same.So i dont believe it's due to the wrong user name and password. And ...
0
votes
0answers
21 views

mysql Adding date/time stamp to file produced, or other method of automated file naming to keep resulting files unique

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE stmaster.internal ...
0
votes
1answer
69 views

Cannot connect to port 3306 on a remote MySQL server using MySQL Workbench in Mac OS X

I want to access MySQL remotely: GRANT ALL ON *.* TO thufir@'192.168.0.16' IDENTIFIED BY 'hfdks4329vjkl'; When Workbench failed to connect, I took a look with ping and telnet: Brents-MacBook:~ ...
1
vote
0answers
27 views

Mysql- Changing file name to include date/time stamp when query is run

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE ...
0
votes
0answers
31 views

Restoring the XAMPP installation in Mac, MySql

I have a XAMPP on Mac Yosemite that during a mess I was having, I copied the entire directory under /Applications/XAMPP/ to another location. Then I copied it back, but its not working, Apache runs, ...
0
votes
0answers
19 views

boost application process in ubuntu

Are there other ways to boost an application process in Ubuntu other than "nice"? I want to backup a database without using import and export method and just use push and pull method instead. I tried ...
0
votes
0answers
14 views

ISPConfig3: No PHP MySQL function available

This message is given when I configure ISPC3 with php -q install.php The ISPC3 output: ISPConfig3: No PHP MySQL function available. Please ensure the module is loaded. I've tried to install the ...
-1
votes
1answer
76 views

how to upgrade Mysql 5.5.30 to 5.6.21 in Amazon ec2

The current installation of mysql is 5.5.30 and it is in Amazon ec2 I want to upgrade it to 5.6.21 I used sudo apt-get install mysql-server=5.6.21 But it says: Version '5.6.21' for ...
0
votes
0answers
50 views

FreeBSD with MySQL 5.6 installed fails on first launch

I am trying to start MySQL for the first time. The install_db script runs error free I used: mysql_install_db --user=mysql --basedir=/usr/local But first launch attempt ends with: 2015-03-10 ...
0
votes
0answers
57 views

Getting error while start mysql in xamp

I am getting an error when try to start mysql in xamp 11:31:58 AM [mysql] Status change detected: running 11:32:03 AM [mysql] Status change detected: stopped 11:32:03 AM [mysql] Error: ...
0
votes
1answer
49 views

Uninstall specific version of mysql OSX

I installed mysql using .dmg, and then I realized I already have mysql installed. Now I have two versions, and I would like to keep the one that was shipped with OSX. Is there a way to do it and ...
0
votes
1answer
28 views

Will application version <X> be available natively in Ubuntu version <Y>?

Specifically I want to know if MySQL 5.7 will be available natively (fully integrated, no fiddling with repositories) in Ubuntu 15.04. But I'm really more interested in a general answer, like, is ...
0
votes
0answers
11 views

Gmail and Outlook reading content on compressed files

I have noticed that all zipped documents sent to gmail or outlook is read by their servers. I have sent a Zipped SQL database to my gmail and outlook accounts and then performed a search with some of ...