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
1k 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
131 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
99 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
28 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
159 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
420 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
221 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
757 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: ...
1
vote
1answer
195 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
41 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
18 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
1answer
654 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
301 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
212 views

Eclipse with XAMPP's MySQL and Tomcat

I want to create a Dynamic Web Project in Eclipse, but that option isn't available since Database and local server hasn't been configured. I downloaded XAMPP, how can I use the MySQL and Tomcat server ...
0
votes
0answers
15 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
357 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
2answers
4k 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
113 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
112 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
3k 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
421 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
19 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
262 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
64 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 ...
1
vote
1answer
423 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
263 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" ...
1
vote
0answers
176 views

Set up sftp mysql authentication with chroot

How do I set up an openssh SFTP server that authenticates against a MySQL table where the users are jailed? Each user will need to have its own jail: /home/sftp/john /home/sftp/jane etc.. However ...
0
votes
1answer
26 views

FTP and WWW services don't acknowledge connections

I have Lubuntu 14.04 LTS with vsftpd and the lamp stack (apache2, etc.) installed. Everything works fine on the LAN. Externally, the services don't acknowledge connection attempts. I can see packets ...
0
votes
0answers
16 views

How to identify the database and took backup from another server?

Please guide me in this situation. I have two domains domain1 and domain2, both domain are registered from the different provider but hosted on the same server (server1). My question is that if I ...
0
votes
2answers
855 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 ...
2
votes
1answer
105 views

Why mysqld set user/group of /var/log/mysql with ‘s’ rights?

In Ubuntu, sudo apt-get install mysql-server, the package will: create an account mysql create storage directory /var/lib/mysql with permission drwx------ 4 mysql mysql create log directory ...
0
votes
1answer
243 views

Can't get MySQL server running on Windows 7

I had MySQL up and running several days ago with the help of a friend, but after a reboot I can't get it to startup. My understanding is that I am to run a command prompt as administrator, go the bin ...
0
votes
1answer
112 views

MySQL dump permission error

It seems strange but when doing mysqldump -h host -u backup -p database | gzip > /tmp/test.gz I get Access denied for user 'backup'@'%' (using password: YES) when using LOCK TABLES When ...
0
votes
1answer
142 views

Why do I get this error installing MySQL server?

So I have a empty VPS running Debian 7 32bit. The VPS has just been created so nothing is installed but the base OS. I run apt-get update and then apt-get install mysql-server and i get this error: ...
1
vote
1answer
332 views

MySQL data on ramdisk partition

I'm using Docker with Ubuntu for my CI and development environment. I would like to put the database on a ramdisk partition to speed up the builds, since I have to reload my fixtures a lot, so data ...
0
votes
1answer
30 views

Mysql won't show my databases (MYSQL-WIN7)

I create a database using workbench and don't find this database at ODBC list, I'm able to see only information_schema database. I tried to restart my machine but don't solve the issue. Could you ...
0
votes
1answer
42 views

Centos my.cfg file is incomplete

I recently got a server which has mysql running and I want to access to it remotely. I searched internet and I find out that my.cfg file in /etc/ location has a property that will enable that: ...
0
votes
1answer
619 views

install php-fpm on centos after remoe it

i install php-fpm and php-mysql and nginx then i remove it and update servers kernel. now, when i want to install php-fpm ,.. dont install $>uname -a 2.6.32-504.3.3.el6.x86_64 #1 SMP Wed Dec 17 ...
1
vote
2answers
236 views

How do I use ssh ProxyCommand to connect to remote MySQL server behind bastion host?

Three machines are involved here. Localhost where I do my development. AKA laptop. Bastion host where you must connect first. AKA jump. MySQL server where I want to connect to. AKA DB. My ssh ...
1
vote
0answers
1k views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
0
votes
0answers
99 views

MacOSX Terminal with MYSQL command line how to highlight and copy/paste

Is there a default keyboard command when using the Terminal on MacOSX while in MYSQL command line for highlighting and copying/pasting text? I'm looking for a native solution without having to use ...
0
votes
1answer
205 views

Possible to export/import remote DB to WAMP server?

If I needed to gzip a remote database and import it into my WAMP MySQL database I believe the command I should use is - ssh user@server "mysqldump ericdev | gzip" | gunzip | mysql ericcart But how ...
0
votes
1answer
310 views

Missing MySQL extension required to run WordPress on custom Linux server

I need to get WordPress up on running on a custom Red Hat Linux server, but am getting the following error when attempting to visit the WordPress install page: Your PHP installation appears to be ...
0
votes
1answer
621 views

Table name not showing in relation view in phpmyadmin

I have a database named flk_embriodery. It contains two tables. user countries I created user table from phpmyadmin but generated countried table from mysql query. But interestingly countries table ...
0
votes
1answer
318 views

Compiling MySQL Workbench on Fedora 21 antlr-4.3 jar not found

I'm trying to compile MySQL Workbench This is the result of cmake: -- The C compiler identification is GNU 4.9.2 -- The CXX compiler identification is GNU 4.9.2 -- Check for working C compiler: ...
0
votes
2answers
53 views

Canon Registry Keys Remain after Uninstallation

I have a Canon printer but have found that with it installed I can't correctly install MySQL (there are threads about this problem). So I uninstalled the Canon files, reinstalled MySQL and found that ...
0
votes
3answers
92 views

What is the IP address of my home computer from the perspective of the outside world? [duplicate]

What is the IP address of my home computer from the perspective of the outside world? I need this in order to grant myself permissions to connect to a mysql database on a work server. I'm working on ...
0
votes
2answers
75 views

MySQL error, Too many connections

When I try to see my website, instead of the forum that I was uploaded on the host, this below screen appears : me, as the one who bought a domain and a free host, what must do to solve it? As you ...
0
votes
2answers
120 views

How can I pass the result set of filenames from an MySQL query to zip in Linux

My problem is pretty straight foward, and I think I'm close but need a boost in the right direction. I have a MySQL table that contains a lot of file names that are used by a website. These files all ...
0
votes
1answer
226 views

Mysql Connector crash on SQL Server 2008

I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...