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
5 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 ...
-2
votes
0answers
16 views

MySql does not work for some time after restart [on hold]

I am using Mysql version 5.6.19 on Ubuntu 14.04.1 I have a peculiar problem on my server. When I restart the server mysql takes around 150-200% CPU when I use the "top" command in Linux some ...
-1
votes
0answers
22 views

How can i make my http server look like its from brazil? [on hold]

So i have created a http server http://impulzz.comuf.com/cstrike/ and its located somewhere in the US, so when i do a trace route some city in the US comes up, I would like to make it look like this ...
0
votes
0answers
13 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
22 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
12 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
17 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
39 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
17 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
21 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
17 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
11 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 ...
0
votes
0answers
5 views

How to save many changes to database data? [migrated]

I'm working on a feature which will pull many (say, 1000-5000) rows from a database, display them to the user and allow the user to edit them. This editing may involve changing text; adding rows at ...
-1
votes
1answer
41 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
35 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 ...
1
vote
2answers
34 views

MySQL database is marked as crashed

Recently my website fell and trying to find a reason of this down i have met the following error message in MySQL 5.0 log files: Table './DB/xxx' is marked as crashed and should be repaired I have ...
0
votes
0answers
29 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
votes
0answers
27 views

phplist is showing blank page after installation

I installed phplist on goDaddy VPS Server on CentOS. I have completed installation successfully. But now it is showing blank page. I tried so much. I also installed new fresh copy but it is not ...
0
votes
1answer
36 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
23 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
25 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
36 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
11 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
67 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
63 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
33 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
16 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
111 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
62 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
7 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
70 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
53 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
46 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
51 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
40 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
14 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
9 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
1answer
211 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
33 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
48 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
32 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
46 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
58 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
26 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
9 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
30 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
427 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
26 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
64 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 ...