MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
0answers
130 views

Adding new word characters to UTF8 encoded mySQL table for a fulltext search

I have found in the docs where it describes how to add characters to the list of word characters used during fulltext searches. My table is encoded UTF8 and from what I can see, there isn't a ...
0
votes
1answer
439 views

Unable to connect to database as created user - ERROR 1044 (42000): Access denied for user

I have a redhat linux server with root password A When setting up MySQL, I gave it a password B (not A) I need to connect to 'mydatabase' as user 'myusername' Listing users shows: mysql> select ...
0
votes
2answers
98 views

Change of mysql db password brings down website

Each time I change the MySQL db password, and update the dbconfig file, the website is down. I also flush privileges Any idea why?
2
votes
4answers
3k views

IP tables modification to allow access to mysql on CENTOS 5 server

CentOS 5.4, with IP tables stopped, I can do it. What's the line I need to add to IPtables so I can keep it on and have remote (domain) access to the mysql databases? my current table: # Firewall ...
4
votes
1answer
8k views

MYSQL remote read only access, how do I set it up?

I've seen stuff on how to enable remote access, but never how to restrict it so that users cannot make any changes. I tried doing this: mysql> create user 'dude'@'boingoboingo.local' IDENTIFIED BY ...
0
votes
1answer
2k views

Installing PHP with MySQL support?

I've got PHp installed from my hosting provider and it doesnt seem to have mysql support built in. I was redirected to an installation script: /usr/bin/mysql_secure_installation Which installed ...
3
votes
4answers
776 views

Disk encryption in Debian

I have a Debian Lenny server running a production application. Recently, we are being asked by a consultant to enable disk encryption for data security. He believes full disk encryption will require ...
1
vote
2answers
88 views

mysql installation fails

Whenever I try to install mysql 5.0.77 on CentOS 5.5, the installation goes fine. So the whenever I try: mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user ...
1
vote
3answers
1k views

Trying to start mysql

I am trying to start MySQL on CentOS so I run service mysqld start but I get the following error: Timeout error occurred trying to start MySQL Daemon When I look into the logs, this is what I get ...
0
votes
1answer
230 views

MySQL connections - RAM or Processing?

I know the queries utilize more processing, but the connection itself, does it use more RAM than processing?
1
vote
1answer
122 views

Cross-database & multiple data connections

How bad is it to have 4-5 connections on a single page? Is it like, horribly bad? I mean to different databases. I have the following databases.... core account ads starcraft diablo forums ...
1
vote
1answer
239 views

MySQL: Not much activity, but thousands of network connections remain in TIME_WAIT"

We are running MySQL 5.1.33 on FreeBSD 7.2-RELEASE. This is a development database server attached to a development webserver running Silverstripe and PHP 5.3. This morning, the development ...
0
votes
5answers
336 views

Should we use Remote access for mysql

I'm not a system guy, this is first time I'm setting up a system. I have a remote system as developer point of view it would be good for me to have a remote access to the database. From security ...
2
votes
1answer
477 views

Why do I get a “using password: YES” error even when I don't give the -pXXXX parameter?

I'm getting this error when softweb:~ # mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I'm not even inputting the password and its telling me that I'm ...
0
votes
3answers
598 views

Rebuilding corrupt slave by copying mysql folder

Rebuilding an existing slave from a master using cold-copying of /var/lib/mysql, would this be the proper process/order? Anything missing? master mysql> SHOW MASTER STATUS\G (take notes) slave ...
1
vote
1answer
649 views

Suggested light weight config for LAMP?

Looking for ways to bring down memory requirements for a LAMP install. SITE_INFO: 10-20 pages, 2-5k pageviews per month -- it's a small, low load site. OS: If it matters, I plan to use CentOS-5.5 ...
2
votes
4answers
132 views

Securing MySQL Resources?

Being a newcomer to using and administering MySQL servers, I am looking for resources to get up to speed on the current situation of MySQL Security. Please share any resources you may know about, or ...
0
votes
2answers
170 views

Is there a way to find out the detailed statistics of the querys that processed by Mysql?

The load average of my service is high, always around 15. And the reason for that is the Mysql is overloaded. I'm wondering How Can I find out which specific query/script consume the most Mysql ...
0
votes
1answer
483 views

Setting up Tomcat with pre-existing MySQL from WAMP

I have Tomcat running on 8080 port and WAMP's apache on port 80. Can I use Tomcat with the existing MySQL setup? How do I go about it? I have downloaded the mysql connector java 5.1.13. System ...
0
votes
1answer
622 views

Table seems to be hidden in MySQL DB, query runs fine

I have a sql query done by someone. I cannot seem to see the table where query is reading from, but offline, the table is in the same db. The dbconfig is the same offline and online. Is there any ...
1
vote
2answers
510 views

When is a mySQL permission error not a permission error

So I've been going sort-of crazy for the past few days. I've got a mac, OSX 10.6.4, and I HAD mySQL running on it. At some point after the 10.6.4 update, mySQL stopped working. I got an error ...
0
votes
2answers
616 views

about mysqlimport show warnings

i try to use mysql command to achieve show warnings after execution but my command seems didn't work,what's wrong with the below code,i have tested for many times mysql -uroot -pbin \W ...
0
votes
1answer
142 views

JBoss 4.2 Deadlocking

Greetings, Not sure if this is one for here or stackoverflow but here goes: I have deployed a J2EE application on JBoss 4.2 with a MySQL backend. While stress testing the application I've ...
0
votes
1answer
748 views

Java class issue on Debian 6: java.lang.NoClassDefFoundError: org/apache/commons/pool/impl/GenericObjectPool

I'm having trouble running a script which should rebuild the database for a web service (the Fedora Commons digital repository) which normally runs inside Tomcat 6 (stock Debian version). I'm running ...
1
vote
2answers
2k views

List all mysql users using ssh

How do I list out all users accessing a list of on the mysql server. Thanks Jean
0
votes
1answer
62 views

What is wrong with my permissions

mysql> show databases; ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
1
vote
2answers
668 views

MySQL: Permit user to change his/her _own_ password

On a webserver there is a MySQL-service running, providing databases for the users of the server. Each user has it's own DB and it's own password and the right so INSERT/SELECT/UPDATE/DROP tables in ...
1
vote
3answers
3k views

Mysql 5.1 my.cnf not in /etc/mysql

I installed mysql-server-5.1 on my Ubuntu server using apt-get install mysql-server, but i cant find my.cnf file. It is not in /etc/mysql. In /etc/mysql i have only: conf.d \-mysqld_safe_syslog.cnf ...
1
vote
1answer
223 views

Does CHECK TABLE add read/write locks?

Yesterday I ran CHECK TABLE on a table that is read very frequently. I scanned the MySQL documentation for CHECK TABLE for any mentions of "lock" (and found none) and also noticed that only SELECT ...
1
vote
2answers
221 views

How to verify the users connected and how many requests they are doing on MySQL?

How can I check on my MySQL server the follow: what accounts have an open connection to the mysql-server ? how often they request a new connection ? how many requests they usually do per connection ...
1
vote
2answers
2k views

How to identify DDoS attack? [closed]

I am experiencing intermittent, very odd jumps in server load that generally end in server being unavailable. Server runs a pretty high traffic website on Wordpress, Apache, MySQL. There is a ...
0
votes
2answers
280 views

MySQL CPU Usage at 99%

We have a Java based SaaS application running on MySQL database on a 2 GB Linux VPS. Recently we added RAM to the server and since couple of days, MySQL is taking up 99% of CPU usage. We are quite ...
1
vote
4answers
101 views

Switched hosting - MySQL became 10 times slower

I've switched web hosting recently. The new box is slower than the old one (it's VPS vs. dedicated). However, performance testing reports that a good portion of the slowdown is database-driven. I ...
0
votes
1answer
3k views

Fail to set innodb as default engine on Ubuntu 10.04

I've got a problem setting innodb as the default database engine in MySQL 5.1 on Ubuntu 10.04. As soon as I switch to innodb as default engine the server refuses to start. This is what I get in the ...
0
votes
2answers
645 views

MySQL Cluster transaction isolation level - READ_COMMITTED

I'm learning by mostly reading the documentation. Unfortunately, http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html#isolevel_read-committed doesn't say anything, while it says everything. ...
0
votes
1answer
187 views

What is the best way to detect how/where server latency occurs?

I'm managing a small social media site, and its been for the past few days experiencing intermittent server lags. The site will choke loading a page, and moments later, the same page will have no ...
0
votes
4answers
3k views

Configure MySQL server IP

I have a MySQL server which is tied to localhost. I would like to change it to an ip address, for example 192.168.x.x . I tried using the administrator from MySQL toolbench, but i am unable to find ...
0
votes
3answers
270 views

ASP.NET, PHP, SQL Server, MySQL hosting provider for developer? [closed]

I am looking to find a web hosting provider that provides ASP.NET and PHP hosting. The purpose is pretty much just a programming playground for me to develop in and possible show some of my work. As ...
0
votes
3answers
345 views

Extremely Large MySQL Data sets

I'm running Snort in conjunction with MySQL for logging, which is generating ENORMOUS datasets (currently the event table is over 2.5 million, I don't know exactly how much because it only goes up to ...
1
vote
2answers
282 views

MySQL servers for an attendance system

I'm building an attendance system. There are about 20 places where people will check in and check out using a MIFARE 1K card. It will use MySQL as the database. The system will display something like ...
1
vote
2answers
287 views

Will deleting old MySQL data improve performance?

Would deleting old data from my tables improve MySQL query performance? When my queries use indexes? When my queries don't use indexes? When I use InnoDB? When I use MyISAM?
1
vote
1answer
117 views

Using different versions of MySQL in a Master Master setup

We have 2 MySQL server in a Master <-> Master replication, but with an Active/Passive configuration. They're both using version 5.0.75. It's time for us to upgrade MySQL for various reasons and I ...
1
vote
7answers
4k views

How to deploy web application for 2 million users?

I've been tasked with figuring out how to do a large scale deployment for a high availability, high traffic, dynamic, flash based web application. There is a good possibility that this application can ...
0
votes
2answers
144 views

Can you link to a good MySQL dumper PHP script?

I need to migrate a website to another host. I have only FTP server access and MySQL name+pass (the MySQL server's IP I was provided is 127.0.0.1, and there's neither PhpMyAdmin nor SSHell to use). A ...
1
vote
1answer
56 views

I was given a cluster that uses PBS but where do I start MySQL?

I am in a fix. I requested my support people to provide me with some extra CPU and storage resources and they gave me a cluster to work with along with a front-end. The problem is, they are asking me ...
0
votes
2answers
945 views

MySQL error: Can't find symbol '_mysql_plugin_interface_version_' in library

The boring, necessary details: I'm on Snow Leopard running MySQL locally. I'm trying to install the Sphinx engine for MySQL like so: mysql> install plugin sphinx soname 'sphinx.so'; ERROR 1127 ...
2
votes
3answers
327 views

What's the best thing to do when you accidentally delete things from a database?

What's the best thing to do when you accidentally delete things from a database that you shouldn't, restore from a backup?
2
votes
4answers
116 views

MySQL Server : Most Frequent Requests

I would like to know if there is anyway I can display the most frequent sql requests onmy mysql server in order to memcache it. Thanks !
0
votes
3answers
261 views

Database hardware advice [closed]

As a lone developer in my company I'm missing someone to bounce ideas off with. I've been given the task of gathering some hardware requirements for our server so we can make some internal websites ...
3
votes
2answers
3k views

How to set up multiple web and database servers?

My websites have been growing in terms of traffic and the load on the mysql has been increasing. I wanted a solution that would help deal with the increased load on mysql (all queries already ...