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

Share permissions with MySQL in data directory - OSX Yosemite

I would like to have full access (read/write) on everything in the MySQL data directory (/usr/local/mysql/data). Then an application running as "me" could create/edit/delete every data. I tried to ...
0
votes
1answer
8 views

LAMP Setup on CentOS at DigitalOcean

I'm following this tutorial. I got some issues start from step four: Configure Nginx to Process PHP Pages. After I typed this $ sudo vi /etc/nginx/conf.d/default.conf. I can't find server { listen ...
1
vote
2answers
63 views

Issues resetting the MySQL password on an Amazon EC2 'Amazon Linux' instance

Been fighting with resetting the root password for MySQL on an Amazon Linux hosted on EC2. Version: mysql Ver 14.14 Distrib 5.5.42, for Linux (x86_64) using readline 5.1 When installing, I ...
0
votes
0answers
6 views

How can I export my mysql database in webmatrix3

I created a database in webmatrix3 using mysql. Now I would like to generate .sql dump file to create the same database on another machine but I could not find any option to do that. How can I ...
0
votes
1answer
17 views

How to export mysql large database from remote server using only phpmyadmin access?

My client give me phpmyadmin access to do database related task. I am stuck to export the database because database size is very large. Client give me credential like followings: ...
0
votes
0answers
5 views

MySQL Installer Asks for Password But Does Not Seem to Set It

I'm using the MySQL Installer on Windows 8.1. I go through the installation steps for MySQL Server, including setting my password. However, when I go back to reconfigure my server through the ...
0
votes
0answers
18 views

Find missing sequence numbers in table mysql

I have a list like this 1 3 9 10 I want it to be like this 1 2 3 4 5 6 7 8 9 10 all the missing numbers will display I try the following query select l.IDBANK + 1 as start from _bank as l ...
0
votes
1answer
19 views

MySQL 5.6 on Windows fails on Security Settings

I'm installing MySQL 5.6 on Windows 8. I'm doing a completely generic install--I accept all defaults. Yet I get this error: Beginning configuration step: Applying security settings Attempting to ...
0
votes
0answers
9 views

setting permissions for sql reporting sever

I am trying to install Microsoft SQL Server 2014. and received the following error Updating permission setting for folder 'C:\Windows\Temp' failed. The folder permission setting were supposed to be ...
4
votes
1answer
112 views

MySQL instance lost when upgrading to Windows 10

I had a running instance of MySQL 5.6 in my Windows 8.1. After upgrading to Windows 10, such instance is gone, including the Windows service for it. Server data files are however intact. What would ...
1
vote
1answer
22 views

One server serves over multiple IPs

I am a software developer who happened to buy a dedicated server and 3 additional IPs to host 3 websites. Let's say the main IP is 1.1.1.1 and 1.1.1.2 to 1.1.1.4 for 3 websites. What I have managed ...
0
votes
0answers
27 views

How to track system uptime using a database

I know there are third-party companies that already do this, some even free. However, I want to monitor my own - for the sake of knowledge and experience in doing so. My goal is to setup a central ...
0
votes
0answers
18 views

VS2013 Developer Command Prompt PATH differs from cmd.exe PATH

On Windows 10, I installed MySQL server 5.6 with the VS 2013 integration option. Now when I open the VS2013 Developer Command Prompt, I get: 'MySQL' is not recognized as an internal or external ...
1
vote
1answer
38 views

mysql (mariadb) ERROR 1698 (28000): Access denied for user 'root'@'localhost'

I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked ...
0
votes
2answers
19 views

MySQL sum of column by distinct hostname and by latest date

I have a table that looks like this: DATE | HOSTNAME | MY_VALUE 2015-08-10 | host01 | 1 2015-08-10 | host02 | 3 2015-08-10 | host03 | 4 2015-08-11 | host01 | 7 2015-08-12 | host02 ...
0
votes
0answers
15 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, because even the database couldn't save new rows. ...
0
votes
1answer
17 views

How to monitor mysql percentage disk utilization?

I am new to mysql world and not sure if there is a way to calculate mysql TableSpace/DiskSpace utilization in percentage. I am aware mysql does not provide upper limit or free space like Oracle DB, ...
0
votes
0answers
20 views

EC2 WP No errors in mysqld.log yet Error w/database connection?

System information: Linux - latest from AWS | Apache - 2.4.12 | MySQL - 5.5.42 | PHP - 5.4.42 memory_limit: php 128M | wp 64M Running new m3.medium instance and having the database connection issue ...
0
votes
0answers
35 views

OSX Homebrew MySQL Installation Gone Bad

I'm having issues with getting mysql installed properly under homebrew. I want homebrew to manage it, and I had it installed manually using the .dmg installer beforehand. I've backed up my data into ...
0
votes
0answers
15 views

MYSQL LongBLOB ,Search need to avoid image data

I am using Mysql longblob for store the content (image and text ) problem is , while I am searching a text through my appliction , if any word similar to the search string in longblob (image ...
-1
votes
0answers
20 views

Localhost server is working but not with ports

I manage to start some Game servers which uses 127.0.0.1. I have XAMPP installed with Apache & MySql servers running on. The issue I'm facing is that localhost and 127.0.0.1 are working fine. ...
-1
votes
0answers
26 views

New install of MySQL Community Server won't work

I'm running OS X 10.10.4 Yosemite and just installed MySQL Community Server. In my preferences pane, it says that it is running but when I connect through MySQL workbench it says "Status: Stopped". I ...
0
votes
1answer
52 views

Can't reset MySQL (MariaDB) root password

Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why. I ...
0
votes
0answers
7 views

How do I modify the definition of a view in Sequel Pro?

I just switched to Sequel Pro (OSX) from HeidiSQL (Windows), and can't seem to find an easy way to modify the base query of a view. Is there something I'm missing? Or do I have to drop the view and ...
0
votes
1answer
27 views

Upgrading XAMPP, mysql tables “lost”

To upgrade from my older XAMPP to a newer one, I renamed the folder C:\XAMPP to C:\XAMPP_OLD and installed the newer version with xampp-win32-5.6.8-0-VC11-installer.exe into C:\XAMPP. Then I ran ...
-1
votes
1answer
25 views

Trouble setting up the class path for MySQL and running MySQL via terminal

Question: what is the easiest way to run the MySQL app from the terminal What I have tried: Using some stackOverFlow suggestions I have used the following commands echo $PATH, produces ...
2
votes
1answer
30 views

CentOS - Trying to backup/restore a MySQL database?

My CentOS 6 server got a server issue, so customer support took a backup of my server and reinstalled it. The backup is in a folder called /home/42406. I'm trying to find my MySQL database called ...
0
votes
1answer
46 views

Best way to implement a GUI under Debian Linux [closed]

I'm currently using Bacula backup software under Debian Linux, all is good except the fact that it doesn't come up with a GUI. I had a look at all existing GUI out there, but none of them is what I ...
0
votes
0answers
19 views

PhpMyAdmin unaccessible from Internet

I have read about and tried other configurations of the web-based PHPMyAdmin and they don't seem to work. My environment is a CentOS 6.6 with Mysql server installed and configured before PHPMyAdmin ...
0
votes
1answer
57 views

Merging two *.db files with same tables into one *.db file

I would like to combine two mysql database files (*.db) into a single database. Both databases have the same tables. Is there an easy way to do this?
0
votes
1answer
54 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
2
votes
0answers
38 views

Logon and Logoff scripts not running

I have set SQL queries to run on logon and logoff using group policy editor. But sometimes scripts do not run. logon.bat @echo off echo INSERT INTO UPTIME(INTIME) VALUES(NOW()); > abc.sql mysql ...
1
vote
1answer
39 views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
0
votes
0answers
113 views

Arch (Linux): Failed to start verifying integrity of password and group files

I have just started installing arch and installed numerous programs, one of which is mysql. Upon starting linux, I recognized this error [FAILED] Failed to start verifying integrity of password and ...
1
vote
0answers
23 views

Find web server architecture [closed]

I am programming mostly small webs with php and mysql with 10 000 visitors per day. Now I have a web with 50 000 visitors per day and this number still increases. Visitors will load from 50 to 80 ...
0
votes
1answer
11 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
0
votes
0answers
26 views

Postfix install fails. MySQL conflict

I'm using CentOS 6, and trying to create a virtual mirror on a new server of an old one (which someone else setup). As much as possible, I want keep everything with the same version, but I've started ...
0
votes
1answer
38 views

User cannot login to MySQL from localhost with Host set to %

I installed XAMPP 5.5.24 onto another machine (OS X 10.6.8) recently. I created the DB for my application and a user for connect to it. However, I was facing the following problem: The user was not ...
0
votes
1answer
16 views

How to change readline scroll behaviour on OS X?

I'm SSHing in Mac OS X Terminal to two ubuntu servers, then I connect to various readline-enabled shells, like MySQL or Mongo clients. Recently, it seems that somehow the scroll behaviour changed. ...
0
votes
0answers
36 views

I've to give my final year project on CD. How can I make sure it requires minimal efforts to run?

My project details: JavaEE pure JSP/Servlets MVC MySQL Tomcat Pressing ^Ron IntelliJ was easy. Now I have to give my project in a compact drive. What can I do so it does not require much effort to ...
1
vote
0answers
34 views

is there easy auto config software for setting up postfix/dovecot/mysql? [closed]

I'm really pulling my hair out on this one. I have installed all of the apps mentioned above, along with webmin and postfixadmin. Webmin gives me settings for dovecot but asks for a sql configuration ...
0
votes
0answers
18 views

Use heroku instance as a Mysql database server

I have a hosting plan which limits disk usage and I see that heroku or some other free hosting plans could come as rescue , so that I would just use their Mysql database component remotely for my ...
0
votes
0answers
30 views

MySQL Freezes System Preferences then Crashes Mac OSX Yosemite

So I'm trying to set up my Mac Mini as a webserver, OSX Yosemite. Ive installed MySQL but when I try run it from the preferences pane everything freezes then eventually crashes. The version of MySQL ...
0
votes
0answers
22 views

Change MySQL Installer for Windows update prompt period. Daily is too often

MySQL Installer for Windows - Community opens a console window about once per day to prompt the user to update a catalog and other things. A once per day prompt is very annoying. How can I change ...
2
votes
3answers
99 views

Can't include an HTML link in PHP script, but works fine as MySQL query

I'm using the following as part of a PHP script: mysqli_query($con,"UPDATE table SET description='<a href="http://123456.biz/index.php/123/321/456/*/789">text</a>' WHERE description IS ...
1
vote
0answers
89 views

Windows 7 web browser cannot access localhost

I'm using windows 7 and installed xampp, but I can't access localhost from all web browser (IE, Chrome, Firefox), it always give me "ERR_CONNECTION_REFUSED". I already googling it and found many ...
0
votes
0answers
69 views

MySql Remote. WMI connection setup does not work?

Hello i want to do a remote server on mysql that is on my computer soo i can connect to it outside network but i have a problem that i cannot solve my self. PROBLEM When i enter my windows 8 login ...
1
vote
1answer
18 views

What is the name of the daemon process of mysql in OS X?

I have just installed mysql in OS X and this code works fine: String url = "jdbc:mysql://localhost:3306/"; String dbName = "information_schema"; String driver = "com.mysql.jdbc.Driver"; String ...
0
votes
1answer
67 views

Mysql remote server with rights to WMI

I just fixed and got my MySQL running on my computer on port forwarded with all the grants. However, when I am enabling remote server Windows asks for user login information for WMI I need to enter ...
0
votes
0answers
37 views

MAC OSX Terminal (TERM)

I am using debian wheezy, I installed mysql but when I login to mysql using command mysql -u root -p and then after typing my password, I don't see any output. According to log file I am successfully ...