1
vote
1answer
141 views

ERROR 1044 (42000): Access denied for 'root' With All Privileges when root user is missing in plesk installation

My provider has supplied a Ubuntu 12.04 LTS LAMP installation with a bunch of software preinstalled. The system is supposed to be mantained using Parallels Plesk (which I unfortunately didn't know ...
0
votes
1answer
180 views

Plesk error when adding a subscription: ODBC error #08S01 can't connect to local MySQL

I'm getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription. Internal error: ODBC error #08S01: ...
0
votes
2answers
35 views

Apache Configuration not use server capabilities

I have a web server with 16 GB of RAM. The server has a good traffic and have pics of 300 simultaneous requests. Unfortunately when these peaks arrive queries fall into error or are very very slow. ...
0
votes
0answers
66 views

mysqlnd_ms + PLESK + MYSQL connect fails // replication split read/write failed

I am running a centos 6.4 server with plesk panel. I have successfully installed mysqlnd. php -i shows that its correctly using it. I have also installed pecl mysqlnd_ms to split reads/writes. I have ...
0
votes
0answers
86 views

Modifying open base directory on Apache VPS server and MySQL problems

I have an Apache VPS server that I'm having some configuration issues with. I'm using an open source PHP social networking program that needs to be able to write to a data directory that's on the ...
0
votes
1answer
291 views

Migrating local databases to new a Plesk server pointing to external MySQL server, databases are created locally

First of all, this problem is not the same as the one referenced at When migrating to Plesk 11 database is created on localhost not DB server. This one happens when we try to migrate clients from an ...
1
vote
2answers
424 views

MYSQL logs of user activity by IP address [duplicate]

I have a website to which I have allowed someone to enter to make some modifications. However, I have discovered that they made changes that compromised the security of the website and I know that the ...
0
votes
2answers
549 views

Plesk: access mysql as root

I cannot access MySQL as root on my Plesk 10.x + (Linux) VPS. Apparently Plesk disables the root account and replaces it with admin with the same password as your Plesk login, but access is still ...
1
vote
3answers
160 views

Ubuntu server failing daily

Symptoms: Server becomes unresponsive - Increase in load, all services stop Loss of connectivity - Ping/SSH Flush MySQL hosts after reboot - As MySQL refuses new connections Intermittent Apache ...
0
votes
1answer
847 views

Set mysql user rights with plesk

With Plesk (v. 10.2.0) I can create multiple user accounts for a MySQL database. I however seem not to find a way to restrict one of the user accounts to read only access. The created users do not ...
0
votes
1answer
569 views

Parallels Plesk not enough memory

Parallels Plesk shows: ERROR: PleskFatalException Unable to connect to database: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 12); if you are not out of ...
0
votes
3answers
302 views

apache to nginx?

I need to be able to use .htaccess, PHP 5, MySQL 5 on new configuration. While I was looking for a way to increase server performance, someone suggests me to change my current system, Apache + Plesk, ...
0
votes
2answers
1k views

www-data@localhost using password NO

I use plesk 9.3, which is required by Serverloft. We are hosting on 24 websites on it. First, it said too many connection error, and then when I search the main problem. The problem is: Warning: ...
0
votes
0answers
477 views

Plesk Run-Time SQL Server is gone and not starting

As you see there; https://212.95.46.68:8443/ I'm having a problem. The problem is Plesk SQL Server is not working (MySQL) and not starting. What should I do to start it? The error is: Could not ...
0
votes
2answers
408 views

CentOS/yum - Upgrading php 5.1 -> 5.3 without upgrading mysql 5.0 -> 5.1

I'm attempting to upgrade php from the centos default of 5.1.6 to 5.3.8 out of the Atomic repo, but when doing so, yum wants mysql to upgrade from 5.0 to 5.1, saying that php-mysql-5.3.8-1.el5 is ...
0
votes
2answers
680 views

Port 3306 on ssh is perfect but not when i use php to do a MySQL connect

I'm trying to set up my server to accept remote connections to MySQL. It now works using this command within ssh : mysql -u testuser -h my.ip.address.here -p but when i try to do a mysqli connect ...
0
votes
2answers
1k views

Plesk broken after MySQL upgrade

I have a Virtuozzo VPS on a CentOS 4.4 box running Plesk 8.6. I upgraded MySQL from 4.1 to 5.0, but I had to use rpm -Uvh --nodeps to get around some Plesk packages that were dependent on ...
1
vote
1answer
1k views

Accessing phpMyAdmin as Admin on Plesk?

I cannot figure out how to login to phpMyAdmin as root/admin on my Plesk VPS? I can log in as individual users but I wish to login as root so that I can play around with privaliages. Any ideas? I ...
0
votes
2answers
655 views

MySQL rotating backup script - plesk

I have a MySQL backup script I picked up somewhere (can't recall where). It works when I run it manually, but run on cron as root it doesn't run for some reason. There may be a cron log I can check ...
0
votes
1answer
1k views

How to recover a MySQL InnoDB table?

When I try to launch the Plesk administration page of you server I get the following error: ERROR: PleskMainDBException MySQL query failed: MySQL server has gone away The MySQL Server is working ...
0
votes
1answer
307 views

Upgrade MySQL to 5.1 on Ubuntu Plesk VPS

Is it possible to upgrade MySQL to 5.1 on a VPS running Ubuntu 10.04, without breaking Plesk?
0
votes
1answer
2k views

Not able to manage DB using Webadmin in Plesk

I have a VPS running on CentOS 5 with Plesk 9. I've just added a DB and setup WP. Now I need to access DB using phpMyAdmin. The problem is that phpMyAdmin is not laoding when I click WebAdmin. I've ...
0
votes
1answer
843 views

Plesk admin password for MySQL

Does anyone know how Plesk stores MySQL admin password? I accidentally changed the admin password in MySQL's user table which was set by Plesk and now Plesk is broken.
0
votes
2answers
1k views

Upgrade MySQL on Plesk on Windows

I just got a nasty surprise when I installed a website in Unicode Hindi (Indian language) on a server, all freshly entered unicode data is turning into question marks on the server. On my dev machine ...
0
votes
3answers
190 views

mysql linux persmission to apache owned folders

I want to be able to load files to the database using SQL (mysql) from a web directory (apache httpdocs directory) on a centos machine that runs apache, mysql and plesk. I understand I need to give ...
0
votes
1answer
290 views

Add multiple databases to one user

How do you add multiple databases to one user using either Plesk or PHPMyAdmin?
1
vote
6answers
12k views

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

Overnight one of our servers had too many connections. Upon rebooting I now get the following via Plesk: ERROR: PleskFatalException Can't connect to local MySQL server through socket ...
1
vote
3answers
187 views

what would be the process that you debug a webserver for issues of performance where you are getting downtime?

Unfortunatly this is somewhat of a vague question. But one i face every now and then. Right now my server is a fully managed CentOS 5 - Plesk 9.2.1. In recent days the server keeps choking where ...