-1
votes
1answer
16 views

Telnet to localhost 3306 looses connection to host after few seconds

When I try to telnet into my localhost port 3306 which belongs to mysql, it shows me the hello packet, then looses connection after a few seconds. My skip networking is set to OFF, I have started and ...
0
votes
1answer
63 views

After editing my.cnf MySQL fails to restart

I want to edit the /etc/my.cnf file. I've tried to use this as the file content: [mysqld] set-variable = max_allowed_packet=24M set-variable = max_connections=300 log-slow-queries safe-show-database ...
0
votes
0answers
11 views

Mysql access over LAN [migrated]

I have created a java application which connects to a mysql database using the JDBC driver. I have the mysql server running on the same machine as my java application. When i connect to the database ...
0
votes
1answer
56 views

Taking database from possibly cracked server

I have a server which is behaving erratically. While I investigate if it's been hacked, I'm also thinking about my backup options: As many posts have said the only way to truly know you're clean is ...
-1
votes
0answers
31 views

MySQL Server Is Slow

I have two MySQL servers and one was just recently setup. The one I just recently setup is a bit slower than my older one, which kind of bothers me because I don't want my clients to be upset with the ...
0
votes
0answers
52 views

MySQL won't start after reboot. Exiting with signal 11

last night I was doing a server maintenance that required DB reboot. No changes in a config were made. Current setup is as follows: master (server1) - master (server2) and slave (server0) MySQL ...
-2
votes
2answers
359 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using Password:YES) [on hold]

root@test-2:/usr/local# mysql -u root -H 192.168.x.xxx -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
0
votes
0answers
90 views

MySQL Workbench Could not connect to Source DBMS

I have a server which has a MSSQL database and i trying to data migrate from MSSQL to MySQL, in the first stop after i choose database --> data migrate --> i choose data system (Microsoft SQL server) ...
0
votes
0answers
52 views

authenticating and authorizing linux users kept in mysql database using pam and nss

I am not able to authenticate and authorize users present in my mysql database. If someone can point out where I am wrong it would be very helpful.Following are the steps that I followed. Firstly I ...
0
votes
0answers
16 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
0
votes
0answers
19 views

What mysql configuration offers the highest write performance

Which multiple mysql server configuration offers the highest write performance? We are looking at changing a web application which is heavy write and want to know what configuration is going to give ...
1
vote
0answers
58 views

Unexplained excessive database response times - very powerful hardware, tiny database

I've a strange problem that's repeatedly troubled me across 3 different servers now. The problem Please see the graph from NewRelic showing the huge amount of time spent in the database. The ...
2
votes
5answers
85 views

MySQL DB Backups: Lockless, Per-Table Restore, MyISAM/InnoDB

The Problem I'd like to implement a MySQL backup strategy on a dedicated server. It has multiple databases on, combined total is about 150GB. Most of this is weighted toward one of the databases. ...
0
votes
1answer
56 views

Cannot open './/ib_buffer_pool' for reading: No such file or directory

I've realised that my Percona DB which has several InnoDB tables doesn't actually have InnoDB buffer pool running as it wasn't specified in the my.cnf. I had a buffer pool size specified of 256MB, ...
1
vote
2answers
41 views

Scaling web application across multiple services

We're developing our web application and have been working on reducing our load times. When we began developing the application, we signed up with a well known hosting provider offering "dedicated ...
-1
votes
1answer
46 views

How to find a database location on server using phpmyadmin?

I am pretty new to managing servers, right now I have trouble to find the location of our database. I see the DB in phpmyadmin, is there a way to find the real location using phpmyadmin ? Running ...
-1
votes
1answer
42 views

Site security - how to filter incoming traffic to a specific port

Just ran a security test on ScanMyServer.com, the results showed a medium risk vulnerability: Database Reachable from the Internet Summary: The remote host is running a database server that is ...
0
votes
2answers
253 views

MySQL - Slow query - wp_options table. Website unable to handle traffic

After spending several days researching, I have placed a website on a c1.medium instance, Amazon Linux, and the MySQL database on a db.m1.instance. The RDS is running MySQL version 5.6.13. I have ...
0
votes
1answer
73 views

WordPress - MySQL server has gone away

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
0
votes
3answers
68 views

Amazon Linux EC2 Webserver / MYSQL Upgrade – Traffic causing error establishing a database connection

To give you a little background, I currently have a website that allows users to upload photos. The website was initially on a GoDaddy shared server, but recent surges in traffic have forced me to ...
1
vote
2answers
94 views

mysql fails every day at the same time and when many requests occurs

I am some problems with my mysql database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems. The first: Every day ...
5
votes
4answers
403 views

Is MySQL required on both the database server and the webserver? why?

Is MySQL required on both the MySQL database server and the web server that it is connecting to? If it is required on both the web server and database server, please explain why this is. Moreover, if ...
0
votes
2answers
3k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
-5
votes
1answer
53 views

Ticketing server database security [closed]

I want to setup a ticketing system which will show the seats available instantly. However, for security, I do not want to open my database in internet. I want to setup a server which has public IP and ...
0
votes
2answers
50 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
1answer
28 views

MySQL Replication fix after server shutdown/start

Server1 is Master Server2 is Slave Both are in our AWS testing env and we stop them once done with our work. When start again, Master rotates/creates new binary log file but slave keep looking for ...
0
votes
1answer
117 views

MySQL Creating a Database CentOS (6 - 64bit) Error 1064 (42000)

When ever I type in : GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'; It gives me an error of : ERROR 1064 (42000): You have an error in your SQL syntax; check the ...
-2
votes
1answer
49 views

Adding and Removing MySQL Databases via CentOS 6 - 64 bit

I have a VPS, and am having troubles with MySQL. I think I have created a database, but got lost. I need to know how to: Add a database, with the username, name of the database, and password. ...
0
votes
2answers
168 views

Connect to MySQL EC2 Instance outside of VPC

I have a VPC setup with a few EC2 instances inside. I'm attempting to connect to a MySQL database on an EC2 instance outside the VPC, with no luck. I have the security groups on the VPC EC2 ...
0
votes
1answer
35 views

Mysql Db replication

I have the following setup: 3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3. I need ...
0
votes
1answer
42 views

Confusing MySql Error

I am trying to install an application on CentOS, and see this error in my apache log. If any can help me understand what exactly is the case, I can try to work on a solution for the error. This is ...
-2
votes
1answer
32 views

Transfer database from Red Hat Linux to WAMMP [closed]

I've currently got a MySQL 5.X database on a server running Red Hat Linux 4 (from memory), which I currently shell into with Putty. I now need to replicate the server in WAMP for offline debugging, ...
0
votes
2answers
97 views

Will re-installing phpmyadmin will have any effect on my Databases?

I am quiete new and somehow I crashed my phpmyadmin website, it can't be displayed without errors after changing the port of it once. So does it has any effect on my databases when I reinstall my ...
2
votes
1answer
568 views

Database (MySQL) and SSD lifetime - “lot” of writes to DB

In company where I work we started using SSD for our internal 3 GB MySQL database Difference in perfomance is HUGE, which is great. What I am worried about is lifetime of SSD Writes to DB are ...
1
vote
1answer
294 views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
2
votes
4answers
389 views

How can i create in incremental backups of mysql databases

I have linux centos 6.4 server with mysql5.6 I have the cron job for making hourly mysql database backups like this Its in python os.popen("mysqldump -u %s --password=%s -h %s -e --opt ...
-1
votes
1answer
50 views

Server A cant connect to Severs B's mysql database [closed]

I have two servers both running mysql on Ubuntu 12.04. I have an application on Server A which has to connect to Server B's database. I have opened the my.conf file on server B and make the ...
0
votes
3answers
54 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
2answers
104 views

MySQL server on openstack

I want to set up a MySQL database that is easy to scale. Traditional, off-cloud scaling means (1) upgrading the hardware, (2) sharding, or (3) replicating. Option 1 is easy but is limited. Option 2 ...
-1
votes
1answer
68 views

Setup Postfix and Dovecot with mysql but can't receive mail for users defined in database

I setup Postfix and Dovecot with mysql but can't receive mail for users defined in database. Actually I can login to webmail and even send mail. Remote host said: 550 5.1.1 ...
-1
votes
2answers
225 views

How to regain access to myql server and dump database?

We retake the management of our server and now we need to make some reverse engineering. We gave to an external company the development of our new Website and they need a dump of database from old ...
0
votes
1answer
66 views

How to arrange a replication in mysql?

Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that, no surprisingly, database is the bottleneck. I have two servers to handle the site: A ...
0
votes
0answers
77 views

Strange CPU cycles and slow queries

My database (XAMPP) runs at almost 350 questions a second is 99% in the SELECT category. The website I'm running is heave on timed ajax calls that refresh data every 10 seconds. During this, there are ...
-1
votes
1answer
33 views

InnoDB Failure of some kind [closed]

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
-1
votes
1answer
838 views

mysqld 5.6 service error 1067

Upon running this service "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 I get this error windows could not start ...
0
votes
2answers
155 views

Can't start MYSQL after changing directories

So I started running out of space on my linux hard disk. I added another hard drive and now I want to change the MySQL directories. So instead of saving the data into the old hard drive, it saves it ...
0
votes
1answer
30 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
0
votes
2answers
757 views

How do I get my ubuntu server to listen for database connections?

I am having a problems connecting to my database outside of phpmyadmin. Im pretty sure this is because my server isn't listening on port 3306. When I type: sudo netstat -ntlp on my OTHER working ...
-1
votes
1answer
39 views

Improving Database Performance [closed]

I've heard that you can do something like the following in my.cnf to get better performance: tmpdir = /dev/shm I'm running MariaDB and wondering is this a good idea? All it does it create the ...
0
votes
0answers
104 views

Mysql database on ubuntu server not accepting connections

I am having problems with my database. The only way I can connect to it is via phpmyadmin. I try to use the same username and password to connect to the database in 'SQL PRO' and I get the following ...