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
1answer
7 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
15 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
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
1answer
3k views

MySQL ERROR 2002 (HY000) on CentOS 5

I have problem with starting up mysql. When I type service mysql start All I got is ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock' (2)** ...
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 ...
1
vote
1answer
8k views

WAMP - Reset Root password on mysql

I'm getting this error: access denied for user 'root'@'localhost' using paswword (NO). Its a fresh install of wampserver 2.2 32 bit. Is there a way I can reset the mysql root password? I have tried ...
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 ...
0
votes
1answer
4k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
-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 ...
3
votes
3answers
4k views

Error message: sudo: mysql_secure_installation: command not found

I'm trying to learn PHP and I'm just in the process of installing apache,msql and PHP. I'm on a mac osx 10.7.2 I downloaded: mysql-5.5.18-osx10.6-x86_64.dmg I'm now at the point of setting the ...
1
vote
2answers
468 views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
0
votes
1answer
29 views

MYSQL UTF8 characters encoding issue [on hold]

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 ...
1
vote
2answers
220 views

MySQL does not work on MacBook Pro after restoring from Time Machine

I just used Time Machine to restore my hard drive. However I am not able to connect to MySQL. I get the following error when I type mysql -u root -p. ERROR 2002 (HY000): Can't connect to local ...
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
1answer
37 views

How to restore Debian server's /var/lib datas

I made a big mistake : While administrating and making settings, I accidentally deleted /var/lib folder. The result is that I can no longer use any dpkg commands, so I"ve lost my mysql database. I of ...
1
vote
1answer
4k views

Installing MySQL 5.1 on OS X 10.7 Lion

I am trying to install MySQL 5.1. I am on Lion, and when I remove all files associated with MySQL on my machine it still tells me that I have a newer version installed when I try to install it from ...
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
3answers
128 views

Replace string in string but not when its somewhere between double square bracket

I have a long string from mysql field containing the data of a mediawiki page. I have to replace a string in that mediawiki page but not when the string is in mediawiki link. The mediawiki link is ...
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
1answer
5k views

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I've installed xampp on my MAC computer in my table I saw a word named user I clicked it and I saw that I was able to change from not having a password by default to using a password. I clicked it and ...
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
2answers
316 views

Apache couldn't be started because port 8888 is in use by some other software

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
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 ...
-1
votes
0answers
11 views

MS Publisher has no data via ODBC [on hold]

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

Is there a MySQL proxy tool? [closed]

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
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 ...
1
vote
1answer
2k views

Why can't I access MySQL server with port forward rule in router?

This is my setup (the relevant parts, anyway): I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
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
1answer
4k views

Curl Returns “Connection Refused” when trying to access localhost

I am running Xampp (Apache, Mysql and PHP) on my Windows Vista computer. I have curl installed on my machine. When I try to curl my localhost in the command prompt, I get the following: curl -v -i ...
1
vote
1answer
2k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but not ...
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
1answer
61 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:~ ...
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 ...
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, ...
1
vote
1answer
439 views

Installing MySQL with Macports on Yosemite

I am following this tutorial Step 3 (Install MySQL) but it's failing. I am running Mac OS X Yosemite and have freshly installed Macports 2.3.3-10.10. sudo port install mysql51-server failed with "All ...
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: ...