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
42 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
28 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
248 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
54 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
59 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
25 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
37 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
131 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
135 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
266 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
69 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
38 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
17 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
228 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
207 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
133 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
14 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
219 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
1k 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
64 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
51 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
920 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
243 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
16 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
140 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
59 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
190 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
131 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
98 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
20 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
12 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
613 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
65 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
90 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
80 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
86 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
137 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
28 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
0answers
11 views

Suggestions on how to set up my dev server for dev clients (Linux and WIndows)?

I am creating web intranet systems and have always struggled with developing on multiple clients with moving files and databases over back and forth trying to keep everything in sync. I have now set ...
0
votes
1answer
38 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
512 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 ...
0
votes
0answers
113 views

how to enable “sql_auto_is_null” (MySQL 5.6)

in MySQL 5.0 it came enabled by default, but now in 5.6, it's not. So, I need to turn the thing on. i've tried modify my.ini (i'm in a windows box) sql_auto_is_null=1 sql_auto_is_null=ON ...
0
votes
2answers
121 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
611 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
56 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
114 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
175 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
335 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
0answers
38 views

How I can unistall MYSQL5.6.22 installed using source code on Oracle Enterprice Linux 6.6 ?

I have installed MYSQL-5.6.22 using make utility by source code(tar file) and now I can't able am to uninstall it using sudo make clean or sudo make uninstall. So please suggest me the ...
0
votes
1answer
239 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: ...