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

learn more… | top users | synonyms

-1
votes
0answers
5 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
4 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
9 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
11 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
23 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
11 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
28 views

MYSQL UTF8 characters encoding issue

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
14 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
26 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
12 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
11 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
8 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 ...
0
votes
0answers
10 views

MS Publisher has no data via ODBC

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
13 views

Is there a MySQL proxy tool? [on hold]

I love https://mitmproxy.org/: An interactive console program that allows [HTTP] traffic flows to be intercepted, inspected, modified and replayed. I was wondering if something similar in ...
0
votes
0answers
38 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
26 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
8 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
17 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
24 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
14 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
60 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
25 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
27 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
13 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
62 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
45 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
47 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
47 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
24 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 ...
0
votes
0answers
53 views

FreeRADIUS: custom SQL counter only partially working

I want to add to my FreeRADIUS installation a custom SQL check counter. Basically it's the same as Max-Daily-Session but limited to the current Called-Station-Id. I added this to ...
0
votes
1answer
73 views

Login script with PHP and MySQL doesn't work, users from database doesnt appear - probably rookie mistake

I am new at php and MySQL, and I might have a stupid mistake here, but I just cant find it.... The script returns that I have entered wrong password or username, but I am completely sure that both are ...
0
votes
0answers
12 views

MySQL database dumps on Windows 7 when one doesn't know the username, password, database name and host name

I've read this http://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/ but the problem is I don't know the username, password, database name or local host name as I ...
2
votes
1answer
98 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...
0
votes
1answer
113 views

unable to open phpmyadmin Error during session start; please check your PHP …etc

I have installed xampp on ubuntu. I can access on firefox localhost/xampp. However when I go to phpmyadmin on the left it comes up with "phpMyAdmin - Error" Then underneath that it has this: "Error ...
0
votes
0answers
39 views

phpList is not showing Initialize Database Option

I just installed phpList on server. Also created mysql database. Now, I am opening it through ip-address/phplist/admin, It is showing just header. I can't see any option to Initialize Database. Soo, I ...
0
votes
0answers
18 views

Metasploit: MySQL_Login USERPASS_FILE OptionValidateError - won't load any list files

I'm currently working through the Metasploit Unleashed course on offensive-security. I am stuck on this certain part here with some unexpected behaviour ...
1
vote
2answers
162 views

No package available when installing packages on CentOS 6.6

I wanted to install mysql-server on CentOS 6.6 (64bit). When I run yum install mysql-server, I get the following error: root@ip-50-62[/home/syn]# yum install mysql-server Loaded plugins: ...
0
votes
1answer
104 views

Can MySQL handle a string 2 million characters long in BLOB

A search using the title returned 1 question on Stack Overflow, which was not related, and with the MySQL docs 65535 characters was mentioned as a max; but is that ... normal characters or would it be ...
0
votes
0answers
10 views

Modify data values in a MySQL database by means of MySQL workbench?

I'm using MySQL workbench 6.0 on Xubuntu 14 I have tried to create a Database but I don't manage to insert values on the fields by means of the workbench. In fact in my template I have inserted some ...
0
votes
0answers
95 views

Connecting to mysql server at 127.0.0.1:3307 with iptables port redirect

I have a ruby application which, for various reasons, connects to a mysql server running at 127.0.0.1:3307. This works perfectly on the server side, but now I want to run this application on my ...
1
vote
3answers
54 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
0
votes
1answer
62 views

My SQL Workbench crash when I want to save

Sorry for bad grammar, first at all, English is not my native language. :) First, I'd installed MySQL Workbench in my computer Windows 8.1, but when I want to save like a model for example, Windows ...
0
votes
0answers
56 views

phpmyadmin export from two tables where data in one column matches?

I'm running MySql server 5.6.2 with phpmyadmin 4.3.7 on a Windows 2012 server. I have one database - "tsl". Within "tsl" I have a table named "apps" and another table named "flat_apps". The "apps" ...