MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

-1
votes
2answers
174 views

cPanel MySQL 5.5 Server keeps crashing (lots of errors + warnings)

I have a dedicated server (not a VPS/VM) running x64 Centos 6.5 Final + cPanel. The machine has 16 GB memory. I run a game server on this server (which uses MySQL as the back-end for data store). I ...
0
votes
1answer
55 views

remote connection to mysql

have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db here is my connection string used in PC#2: SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = ...
0
votes
0answers
20 views

store mysql database details in linux

I have a test server and live server which has all the files the same (a cio) except I want to connect to a test copy of my msql database on the test server. How secure would it be to have a ...
1
vote
0answers
82 views

resolving host names from parallels (windows) to Mac (mavericks)

I was given a macbook for work that is running mavericks. We also do windows development. I'm currently running windows 8.1. I set up mysql on the mac side that both the windows 8.1 running on ...
0
votes
2answers
38 views

Linux server update

I know that for security reasons the server services have to be up to date, and since my server was attacked by a virus I think this a good time to upgrade the system. Linux sytem: Distributor ID: ...
1
vote
0answers
43 views

Mysql Master database goes offline for a while and slave database do not update data changes made during downtime [closed]

I have configured master-slave bidirectional replication.Both are syncing database properly.When master goes offline/down(disconnected from slave) and meanwhile I make some changes(create/delete table ...
0
votes
0answers
22 views

Bizarre lag in HTTP connection

Running on a LAMP stack, CentOS 6, Apache 2.2.3, PHP 5.4.25, MySQL 5.5.31 Have a very complex web application. It's been running pretty smoothly for about 5 years, now. Of a sudden we've run into ...
0
votes
1answer
62 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
4answers
253 views

Internal server error on user_directory

Today I am trying to install httpd and mysql on my fedora 14 PC. That works fine. After this I try to create a public_html folder on the user directory and allow php to access that folder. For that I ...
3
votes
4answers
838 views

bind-address = ::1 # however, netstat shows 0.0.0.0:3306 LISTENING

I'm running MySQL 5.6 on 64-bit Windows 7 with IPv6 and IPv4 enabled. In my.ini: port=3306 bind-address = ::1 I was hoping to use IPv6 and restrict to the loop-back adapter. I used ::1 instead ...
0
votes
0answers
29 views

Save rows effected from mysql delete statement in bash

I am trying to create a bash script that will connect to my database and purge older records, I would like to keep a record of the number of rows are deleted in a file (lets call it rowseffected.log). ...
1
vote
2answers
68 views

Nagios: monitor mysql auto_increment overflow

Recently we had an overflow in an auto_increment column in a mysql table. Now I'd like to monitor our databases with nagios, so that we'll be alerted whenever an auto_increment column comes near to ...
1
vote
0answers
36 views

How to prevent mysql blobs from borking my terminal

When using the linux terminal client for mysql, every column with a blob prints out tons of control characters and the terminal has to be reset. This looks something like the following Map: �PNG ...
0
votes
0answers
25 views

Reading Text file in Where clause in mysql

I want to look up a table upon certain column whose values are present in text file in mysql. like select * from table where user LIKE '%user1%' here all users like user1, user2.. usern are stored in ...
0
votes
1answer
50 views

Why there is always a tilde (~) sign in the result message in mysql

Whenever I refresh or search anything in the table in mysql, the result message always shows result like this. Showing rows 0 - 10 ( ~11 total , Query took 0.0004 sec) When it is showing the exact ...
0
votes
3answers
43 views

Setting up a local webserver using CentOS on VM

im new here, and basically new at setting up a webserver... now im already googling, and searching here in stackexchange on how to setup a webserver, they tend to direct me to a working server.. i ...
0
votes
1answer
42 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
0
votes
1answer
463 views

MySQL Notifier High Severity Error at startup

When i start MySQL Notifier up and error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when i click over "Show Details" I can see the ...
0
votes
1answer
59 views

How to ensure version 5.5.* for mysql with puppet?

How can i ensure that the latest patch version of 5.5 will be installed by the yum installer under CentOS? class { '::mysql::server': package_ensure => '5.5.*' }
1
vote
1answer
149 views

Can't find mysql data in install directory

I was looking for my mysql data on my harddrive, so i went to the install directory (C:\ProgrammData\MySQL\MySQL Server 5.6\data) but there are only a few of the databases displayed I actually use. ...
1
vote
1answer
169 views

MYSQL fails with: InnoDB: Operating system error number 30 in a file operation

My MYSQL server has been stopping recently about once a week. It requires a reboot to get is working again. But once its rebooted, it will work again for another week or two. The error in question is ...
0
votes
1answer
97 views

mysql_secure_Installation is missing in my mysql installation

I'm following this guide with my new Linux AMI on EC2. After installing mysql: yum install mysql-server And running it: service mysqld start I tried running: mysql_secure_Installation But ...
0
votes
1answer
375 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
32 views

AWS RDS Reserved Instance vs on Demand Instance

I've set up several AWS RDS on-demand instances. Each time, the process was the same, and it included selecting instance type, capacity, storage, etc. When I'm done, and click on the instance icon, I ...
0
votes
2answers
158 views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
0
votes
1answer
877 views

MySQL can't create pid file: Permission Denied

I'm using MySQL on my macbook pro, which worked fine for the last 2 years. A week ago it suddenly stopped and I'm not able to restart it again. I've changed the permission on /usr/local/mysql to 0777 ...
0
votes
1answer
145 views

Start server: /bin/sh: 1: /etc/init.d/mysql: not found

I have tried MySQL workbench on linux mint 14, and got this Start server: /bin/sh: 1: /etc/init.d/mysql: not found error when trying to start local server on it. Please help how to resolve this ...
0
votes
1answer
22 views

Editing finished mysql table

I'm new to mysql and I want to edit my table. My primary key should be auto generated. So where can I get the option to edit my table? thanks
0
votes
1answer
44 views

How to check if mysql server is active in Linux

I'm writing a monitoring script to restart mysql server if it is down in Linux( Centos+Cpanel). Will running the command: "mysqladmin status" be sufficient to be sure that it is fully functional?
1
vote
2answers
179 views

Linux server running out of memory

I have a VPS with a hosting company. I do have some badly written perl scripts tha use MySQL. My MySQL server crashed. The hosting company says the server ran out of memory. At a time when I have ...
0
votes
0answers
21 views

Connecting To MySQL with MAMP via Terminal - Mountain Lion?

I just installed MAMP 2.2 and use OSX Mountain Lion and am having trouble connecting to MySQL via the Terminal prompt; iMac:~ Home$ mysql -u root -p root -bash: mysql: command not found Sudo: ...
0
votes
2answers
77 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 ...
2
votes
1answer
33 views

MySQL “lost” all data (InnoBD)

Today I was making some work with site and I get error what MySQL can't rename file (to make changes in BD). Next I tried to restart MySQL, and it failed to stop MySQL. Then I did go to /var/lib/mysql ...
0
votes
2answers
22 views

MySQL server stopped working

Yesterday, out of the blue, the MySQL working as a backend for my private postfix server stopped working. No log entries, nothing, it just won't start. I reinstalled it and it worked until I copied ...
0
votes
1answer
153 views

Mysql error in Ansible task

Hello I am running Ansible with Vagrant. But with one of of my Mysql tasks I get the following error TASK: [MySQL | Delete anonymous MySQL server user for example.com] **** fatal: [default] => ...
0
votes
1answer
521 views

How to resolve Apache Service path conflict - running both Apache and portable XAMPP on Windows 7

I've got Apache 2.4.7 (Win32) running on Windows 7 and a visiting portable XAMPP on an external drive. After resolving the port issues I'm "only" down with having the "Apache/MySQL Service detected ...
1
vote
1answer
1k views

Can't start MySQL on Fedora 20

I'm a newbie with Fedora and MySQL. I just installed Fedora 20 (virtual), then installed Apache and started it and then installed MySQL. When I tried to start MySQL using this command: sudo service ...
0
votes
0answers
42 views

Analyzing MySQL network traffic usage

I have a MySQL server and an application server (running Python/Celery), communicating via standard TCP. A couple weeks ago, the network traffic between the two servers jumped from less than 1GB/day ...
1
vote
1answer
656 views

What is the difference between MySQL, SQLite and other SQL servers?

I was digging around in my server and I started to wonder what the difference is between MySQL and SQLite and other SQL servers. If anyone can make this clearer, could you also explain if they have ...
-1
votes
2answers
75 views

How to make a MySQL database on Ubuntu server? [closed]

I am trying to make a WordPress blog and install WP manually, but the MySQL databases are giving me headaches. Can someone explain what is MySQL and how to make a database? I am using Ubuntu Server ...
1
vote
2answers
81 views

clear currently edited line in mysql console

What key combination will clear MySQL console command line? I am not sure if this is just a sub scenario of clearing the currently edited line in any Unix/Linux terminal or is the behavior actually ...
1
vote
0answers
500 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
1answer
216 views

SLES11 - DBD: Can't load driver file apr_dbd_mysql.so

We're trying to set up a htaccess authentication with user data from a MySQL database. The part of vhost.conf looks like that: DBDriver mysql DBDParams "host=<XXX> dbname=<XXX> ...
2
votes
2answers
518 views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
4
votes
1answer
66 views

Autostart PtokaX at boot only after mysqld has started

I've the following script in /etc/init.d/server.sh #!/bin/bash ### BEGIN INIT INFO # Provides: PtokaX server # Short-Description: PtokaX P2P server ### END INIT INFO ...
0
votes
0answers
64 views

Trying to run toad for mysql with wine in mint 16

I'm trying to run toad for mysql with wine in mint 16, however I get this error: me@me-mint ~/Downloads $ ./ToadforMySQL_Freeware_7.0.0.2038.exe fixme:storage:create_storagefile Storage share mode ...
1
vote
1answer
37 views

Dual web servers that load balance and point to the same database

So I am currently running a web server at my house with a Raspberry Pi. Quite successfully might I add. The only problem is that sometimes the SD card becomes corrupt and my site goes down for an hour ...
0
votes
1answer
50 views

Understanding Postfix and Courier IMAP

I'm setting up my own mail server, and I'm very new at this... and I'm getting lost. I need your help in determining some parameters the way I know them already, because the configuration is huge. ...
0
votes
1answer
361 views

Using PHPMyAdmin or MySQL Workbench, how to search across 10 tables and return all records matching a specific criteria?

This seems like it should be so simple but I'm having a hell of a time solving it. I have 10 tables named in the following way: b1_settings b2_settings ... b10_settings I need to search across all ...
0
votes
0answers
81 views

Mysql error 28 no space left on the device

I keep running in to the same problem with mysql with error code 28 which means there is not enough space left on the device. Now the weird part is that there is enough space, here are some tips i ...