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

learn more… | top users | synonyms

1
vote
1answer
172 views

Centos 6 - Can't get out of safe mode

So I was going into safe mode from following a tut to fix the error Access denied for user 'root'@'localhost' (using password: NO) And I had issued the following command: mysqld_safe ...
0
votes
0answers
47 views

Trying to migrate a mysql server to AWS

Please advise on how to migrate my local mysql server to the cloud. Currently I have a Fedora linux box and a NAS attached to it via ethernet. I believe the best way to go about it is : Take a ...
0
votes
0answers
31 views

Moved database from Production to development - get 403 error

I exported a Wordpress mysql database from my production server to my development server because I had done some updates on production and wanted them on dev. Now I get a 403 error and no matter what ...
0
votes
0answers
48 views

Connect to MySQL from Integration Services 2012 (SISS)

I am trying to read the schema of a MySQL table on Microsoft SQL Server 2012 Integration Services (SISS), I can successfully "test the connection", get the list of tables, however it seems I can't ...
0
votes
0answers
80 views

mysql store procedure text fili

In MySQL using sqlworkbench, how can I create a procedure for a table to get the input value (only the first 100 rows) from the text file and store it in the database? For example: in the text the ...
0
votes
0answers
43 views

Apache doesn't start in Ubuntu

I'm trying to get my apache2 to work under Ubuntu. I've installed all packages from MySQL to PHP and Apache. When I program on PHP, the PHP scripts aren't recognized and aren't interpreted. I ...
0
votes
1answer
268 views

Can't access server from public wifi

I have a MySQL server (XAMPP) running on my computer and I can't access it from the university wifi. It's working from my home, from my friend's home and on my cellphone (3G), but it just won't work ...
0
votes
3answers
7k views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

So at first I was getting this error when trying to create databases for use in phpmyadmin. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I ...
1
vote
2answers
133 views

Installing from rpm gives weird dependency error

I'm trying to install mysql from rpm file and this is what is get. libaio.so.1 is needed by MySQL-server-5.6.14-1.el6.i686 libaio.so.1(LIBAIO_0.1) is needed by MySQL-server-5.6.14-1.el6.i686 ...
0
votes
0answers
1k views

MySQL Daemon Failed to Start - centos 6

So not sure why I am getting such error. When I type: mysql I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I know that there should ...
0
votes
2answers
125 views

Where to retrieve MySQL Database Backup? Centos 6

Had taken a look at: Where Are Databases Located - MySQL File Location Didn't seem to help much. I used this for a single MySQLDatabase backup: ...
0
votes
0answers
20 views

Unable to view the ouptut in netbeans IDE 7.1 when I use fullscreen

Hi Everyone I am doing a new project on web services, actually I should get output from database and display it in the front end. I have used NETBEANS IDE as the front-end and then I have completed ...
0
votes
1answer
392 views

How do I compare database values in JMeter

I am setting some values in database using REST request via JMeter and I want to verify the set values are committed into database. I'm able to access mysql database using JDBC driver in JMeter ...
1
vote
0answers
321 views

The server quit without updating PID file

I am trying to install MySQL on my Mac w/ Mavericks OS. Whenever I try sudo /usr/local/mysql/support-files/mysql.server start it shows an error The server quit without updating PID file ...
1
vote
2answers
1k views

Clear screen for MYSQL command line client

Please help me.I am unable to clear screen of mysql command line client like i know in case of java it is 'cls'.thanks in advance.
1
vote
1answer
3k views

OSX Mavericks: MySQL homebrew after native install

I recently upgraded my iMac to Mavericks, and I realized I needed to reinstall MySQL. I installed the native DMG version and it was working well, and I should have left it there. But I neglected it ...
0
votes
0answers
45 views

Error installing mysql-server Debian

I've been trying to install mysql-server on my Debian system, and every time the server gets to installing mysql-server-5.5 it always hiccups here [FAIL] Starting MySQL database server: mysqld . . . ...
0
votes
0answers
47 views

Unable to install phpmyadmin on LAMP

I am trying to install phpmyadmin on LAMP on DigitalOcean. Everything is working properly, just checked here :- http://testpanda.com/info.php but when I try to install phpmyadmin using this command ...
0
votes
1answer
317 views

VMWARE ESXi and SSD - ext4 trim discard

I'm running ESXi 5.5 box with Debian as guest OS. and I'm planning to use SSD disk(with ext4) for MySQL database for performance reasons. ESXi recognizes that I'm using SSD disk. But how to let know ...
1
vote
0answers
45 views

Is there any harm in using the MariaDB client to connect to a MySQL server?

I installed MariaDB on my server (both client & server), and now want to also connect to an external MySQL server from it. It seems like although the client command is mysql, the version is ...
1
vote
2answers
7k views

MySQL InnoDB lost tables but files exist

I have a MySQL InnoDB which has all the database table files, but MySQL doesn't see them, and isn't loading them. The problem happened because I deleted these three files: ibdata1, ib_logfile0 and ...
0
votes
0answers
57 views

Unix commands not working

Recently been trying to install mysql and changed my bash_profile around a few times. My unix commands seem to be unresponsive to any of my commands. Need some help to get it back up and running. ...
-1
votes
1answer
178 views

How to quickly insert large amounts of days into MySQL? [closed]

I'm looking for a way to insert a ton of data manually into a MySQL table in the most efficient way. The source data currently lives on a web page (outside my control and so no access to the ...
1
vote
1answer
237 views

Apache/MySQL server blocks

I manage a server running Ubuntu 12.04. In the last couple of weeks, the server has started to misbehave, and I cannot think of anything important that has changed. This is the pattern: The server ...
1
vote
0answers
99 views

Synchronizing folders, configurations, programs, local server and database on 2 debian machines

I am using debian both on a laptop and inside a virtual machine on another computer. I want to be able to synchronize those 2 systems in both ways so that I can do some work say on the VM, then ...
0
votes
0answers
263 views

mysqldump to local mysql database through ssh

This command: ssh bruchowski@www.example.com 'mysqldump -u bruchowski -p dbname' > mysql -u root dbname Produces this error: mysqldump: Got error: 1045: Access denied for user ...
0
votes
1answer
156 views

How do I start mysqld with options

I need to start up mysqld with command line options as from here: http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-grant-tables I normally do sudo service mysqld start, ...
0
votes
0answers
335 views

SQLException: Access denied for user 'root'@'localhost'

I install mysql on Mac with account (root, mypassword). I can connect to the database by this account with "MySQL Query Browser". But, when i try to connect by Java driver, i have got an Exception : ...
1
vote
1answer
434 views

Can I output results of a MySQL query to a csv file via Putty?

I've typed the following code to output the csv file , but it shows an error mysql> SELECT *INFO OUTFILE 'd:/student.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ...
0
votes
0answers
258 views

how to enable remote access to a MySQL server on an AZURE virtual machine

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...
0
votes
0answers
53 views

Switched from XAMPP to WAMP and back to XAMPP and now all sites are sloooow

I am on windows 7 and have been using XAMPP for a year or two with no issues and all my sites running locally were lightning fast. I recently needed to switch to an older version of PHP, so someone ...
1
vote
3answers
2k views

How do I start a MySQL Server in Windows ?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically, now I've restarted my computer it is no longer running, what file do I need to run to get it back up ...
1
vote
1answer
62 views

database statistics and reporting with or without parsing of built in logs

I prefer a generic statistical utility / plugin / application, but don't limit myself as specific might do well too. I want to see a way by which I can see query statistics for ALL queries. e.g ...
0
votes
1answer
1k views

MySQL don't start (ubuntu): [ERROR] /usr/sbin/mysqld: unknown option '--skip-locking'

I can't start MYSQL. I changed a parameter in WEBMIN in the main mysql configuration: SKIP LOCKING OF TABLE FILES?... the original value was "NO", and I changed to "YES" This is the LOG file: ...
1
vote
1answer
58 views

Mediawiki extension error

I'm running the latest version of mediawiki using MoWeS Portable II from my desktop. I just installed this extension on the wiki http://www.mediawiki.org/wiki/Extension:MsUpload It adds an option to ...
6
votes
4answers
502 views

Flash drive friendly (portable) XAMPP alternative?

I'm trying to setup a portable MediaWiki wiki on a flash drive using XAMPP portable as a server. http://lifehacker.com/354005/run-your-personal-wikipedia-from-a-usb-stick When I try to start apache ...
0
votes
1answer
331 views

can Homebrew be used on a Centos computer

I just installed Centos 6.4 minimal on an old computer with an internet connection threw my iMac. Set it up as a development server. Installments required: Nginx, Apache, PHP-5, Mysql, Redis, Mongodb ...
1
vote
1answer
202 views

What will happen if my DB server runs out of disk space?

I'm seeing a huge difference of free disk space between df -h and du -sxh / I've understood in my question Resolving unix server disk space not adding up that du -sxh / is a better estimation as ...
0
votes
1answer
180 views

cannot start mysql server bind socket denied

I have been trying to start mysql server but got this error: Can't start server : Bind on unix socket: Operation not permitted 2013-10-21 13:53:54 25098 [ERROR] Do you already have another mysqld ...
0
votes
2answers
308 views

Backup all plesk MySQL Databases to individual files

Hy, Because I'm new to shell scripting I need a hand. I currently backup all mydatabases to a single file, thing that makes the restore preaty hard. The second problem that my MySQL password dosen't ...
0
votes
0answers
38 views

Issue in starting mysql

I have installed mysql 5.6. when i tried to start mysql, i got this error, [Note] InnoDB: Completed initialization of buffer pool [Note] InnoDB: Highest supported file format is Barracuda. [Note] ...
-2
votes
1answer
133 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
0
votes
2answers
65 views

Is MyIsam safer than InnoDB?

Is MyIsam engine safer than InnoDB about loss of data due to FileSystem error? It seems that InnoDB is not reparable with MySQL tool. I had to choose my engine and I chose InnoDB because of foreign ...
0
votes
1answer
167 views

Double MySQL Running on Mountain Lion

After I've done a full restart, my Apache PHP server doesn't connect to Local MySQL ( connecting via 127.0.0.1 because localhost for some reason fails always ). So I did this today: ➜ ~ mysqladmin ...
2
votes
1answer
88 views

How can I reimage my virtual server to not have size caps to individual directories?

As a prenote, I am extremely new to networking in general, and my knowledge is very minimal, even for things you guys would consider basic. I will try my best to keep up with any advice you have to ...
0
votes
1answer
3k views

Cannot connect to mysql server using IP Address

I am trying to connect to mysql using an ip, but I am getting this error: ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111) I can connect using localhost instead of an ...
0
votes
1answer
490 views

Where are logs of MySQL ? Fedora

Hello I just installed MySQL on my Fedora from Source, with cmake,make,make install etc. It's working, but where can I find logs of the server? I have looked into /var/log, but there is nothing with ...
0
votes
0answers
25 views

Can't find my.cnf on node when my first trying of mysql-cluster 7.2 installation

I follow the MySQL 5.5 Reference Manual :: 17 MySQL Cluster NDB 7.2 :: 17.2 MySQL Cluster Installation and Upgrades document and download the rpm packages (my test os is RHEL 5.5), after installing ...
0
votes
0answers
19 views

Replicating the mysql data without doing mysql sync

i am trying to sync the mysql database between two machines without doing mysql sync(By mounting the mysql installed directory in the other machine). Is there any way to that operation?
2
votes
1answer
800 views

issue on starting of mysql

I have installed "mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz" in user specified directory. I tried to start the lam, but it is saying "Starting MySQL..The server quit without updating PID file ...