Plesk 12.x / Linux :: MySQL Routines And Triggers No Privileges

Feb 16, 2015

I need a MySQL user that has the privileges to add routines and triggers. The default users that are created by Plesk do not have these rights. How would I be able to add these rights to a specific user, or all users, that doesn't care.

I already logged in over SSH as a root user:

Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Then I tried to update the rights of the users:

Code:
mysql >UPDATE db SET Create_view_priv = 'Y', Show_view_priv = 'Y', Create_routine_priv = 'Y', Alter_routine_priv = 'Y';
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

This didn't work. So I wanted to add super privileges by doing this:

Code:
mysql> GRANT SUPER ON *.* TO 'user'@'%' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

But also not of any effect. What's left to do?

View 4 Replies


ADVERTISEMENT

Plesk Automation :: Set User And Privileges From Mysql

Jul 3, 2014

I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.

View 2 Replies View Related

[Cpanel::Mysql]: Not Updating Privileges

Apr 11, 2008

On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin:

Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268

In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error.

I already tried:

/scripts/mysqlup --force
/scripts/upcp --force
/usr/bin/mysql_fix_privilege_tables -u root --password=PASSWORD

View 2 Replies View Related

Backup Mysql User Privileges

Aug 26, 2007

how do i backup mysql user privileges?

this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql

i would like to backup mysql user privileges too.

View 1 Replies View Related

Plesk 12.x / Windows :: Psaadm And Psacln Privileges

Feb 3, 2015

I'm trying to set permission for text file which is exists in Program Files (x86)MyFile directory. File should be accessible by psaadm and not accessible for psacln accounts. I've set permissions for psaadm Full Control Allow and for psacln Full Control Deny.

In my PHP script I'm checking file using is_readable function and no matter which user trying to read this file function always returns true (admin or customer account). I tried to find solution in Web but without success so I'd like to ask you about it.

Additionally, I've tried to create Plesk DiskSecurity XML with privileges settings. After Apply this settings privileges are correctly set for my file, but customers still can read this file.

Is there any other way to deny access to this file for customers and resellers?

View 2 Replies View Related

Plesk 11.x / Windows :: Supplied Account Does Not Possess Administrative Privileges

Sep 1, 2013

I recently upgraded the Plesk to 11.5.30. Now I am not able to create new MySQL databases. I am getting below error.

Code:
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' (using password: YES)

MySQL admin details are correct in plesk database, also the admin has full privileges. I am manually able to create databases, users from mysql prompt. It's just the plesk interface that's giving error.

Code:
C:Program Files (x86)ParallelsPleskMySQLbin>mysql -u admin -p*************** mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 68
Server version: 5.1.68-community MySQL Community Server (GPL)

[Code] .....

View 4 Replies View Related

Submitting POST Info Triggers A Request To Download The Page

Jan 17, 2007

Not sure if this is the appropriate forum to post this question in. If so, please move to the correct forum.

Anytime some creates a new thread or sends a new pm, it will ask them to download the .php page after submitting the POST. I am wondering if anyone else has had this problem and what can I do to resolve it?

View 2 Replies View Related

Plesk 12.x / Linux :: MySQL 5.6 On Ubuntu 12.04?

Jun 7, 2015

I would like to Mysql 5.6 installed on Plesk 12. Is that possible? How does it work?

View 1 Replies View Related

Plesk 11.x / Linux :: How To Upgrade MySQL From 5.1 To 5.5

Oct 12, 2014

How to upgrade mySQL from version 5.1 to version 5.5 on linux. We're running CentOS version 6.3 with Plesk 11.09.

The approach outlined here [URL] .... seems like the way to go. I want to be sure that I don't adversely affect our installation.

If it is at all relevant we're running a Joomla 2.5 site.

View 5 Replies View Related

Plesk 12.x / Linux :: Mirroring MySQL Between Two VPS

Mar 14, 2015

Few weeks ago I experienced storage issues on my VPS. I made webspace copies manually cos I know ovh's standard line means:

- copy is forbidden and vm umount impossible.

Reported machine came back to me but with few broken files. That's why I made a copy... Did know the risk. Their cloud line is acceptable - let's say... But I bought that cheap classic 3 for 12 months

Redundant != copy. But while runing production services, company webspace like I do, it's needed! So it would be fantastic feature from Plesk! Definitely needed! Is it possible?

View 6 Replies View Related

Plesk 12.x / Linux :: MySQL Resources Used By Domain

Jul 3, 2015

I am migrating some clients between Plesk panels ...

After migrate 10 domains the Health monitoring growup from MSQL from 1gb to 4.5gb

All 10 websites are small, how can i see to identify which domain/subscription is consuming a lot of resources?

View 6 Replies View Related

Plesk 12.x / Linux :: PHP Could Not Connect To MySQL Over Localhost

Feb 6, 2015

I have a problem with connection to MySQL database over PHP.

If I define host address '127.0.0.1' works well. Problem occurs if host address is 'localhost'.

How to allow both 'localhost' and '127.0.0.1'?

View 1 Replies View Related

Plesk 11.x / Linux :: Roundcube Can't Connect To MySQL

Oct 5, 2013

With one from another server. Now roundcube does not want to connect to mysql anymore, i tried to edit this :

line:$rcmail_config['db_dsnw'] = 'mysql://roundcube:randompassword@localhost/roundcubemail';

i then used a MD5 generator to input the hash in the password field of the roundcube user in mysql, with no luck...I even tried to delete roundcube user from mysql, then remove psa-roundcube, then go through the plesk update manager and install roundcube again, did not change nothing, it didn't even create the roundcube user.

Is there anyway i can reinstall roundcube from scratch?PPP 11.5 up to date on ubuntu 12.04

Code:

[05-Oct-2013 14:03:54 +0200]: DB Error: _doConnect: [Error message: Access denied for user 'roundcube'@'localhost' (using password: YES)]
[Native code: 1045]
[Native message: Access denied for user 'roundcube'@'localhost' (using password: YES)]

[code]....

View 7 Replies View Related

Plesk 11.x / Linux :: Upgrade MySQL To At Least Version 5.6.5

Sep 22, 2014

I'm still using Plesk 11.5.30 and MySql 5.5.39. That was discribed here how to update. But i need to have a MySql 5.6.5 (minimum) for some software (This version is over 2 years old). I'm using CentOs 6.5. and PHP 5.4.33

how to do this, whitout breaking plesk 11.5.30??

View 4 Replies View Related

Plesk 11.x / Linux :: Where Is Root Mysql Password

May 18, 2014

i have installed phpMyAdmin becouse I don't like the limitation of db management of Plesk, but I can't find the root password to access in it. I read that Plesk rename "root" user in "admin", but I can't find the password. Where is it?

View 4 Replies View Related

Plesk 12.x / Linux :: Upgrading Form Mysql 5.1.73 To 5.7

Aug 28, 2014

I need to upgrade mysql from 5.1.73 to 5.7 but I have applications like lms, cms, and websites that runs with that version with no problems, my question is: Some of you had problems upgrading mysql, because i kwon plesk runs over mysql y i don't want to mess up with plesk.

View 1 Replies View Related

Plesk 12.x / Linux :: Upgrade MySQL From 5.5 To 5.6 (Ubuntu 14.04)?

Nov 28, 2014

I see that Plesk 12 supports MySQL 5.6, but the server I am running is Ububtu 14.04 LTS and comes with 5.5.

I need to make 5.6 available but I can see no way of doing it without breaking Plesk (I already tried just installing it from command line with apt-get install and had to restore the whole server from backup!) - there is no option for MYSQL in Plesks updates & upgrades menu ...

View 14 Replies View Related

Plesk 12.x / Linux :: 12.0.18 With Default MariaDB Instead Of MySQL?

Jul 13, 2015

Did 12.0.18 comes with default maria DB instead of mysql ??

View 2 Replies View Related

Plesk 12.x / Linux :: How To Make Different MySQL Settings For Customers

Oct 13, 2014

We are running Plesk 12.0.18 with MySQL (Server Version: 5.5.33-MariaDB - openSUSE package) on OpenSuSE 13.1

MySQL is running in strict mode and its fine for the most of our customers. But some are trying to run Contenido, thats a CMS, which could work with this mode and we have to disable mysql strict mode.

So my question is: Is it possible to disable mysql strict mode just for choosen customers?

View 5 Replies View Related

Plesk 12.x / Linux :: Multiple PHP Not Working With Installed MySQL

Dec 19, 2014

I've enabled one more php using this guide: [URL] .... but mysql is not working with the new php installation, how to get it working?

View 7 Replies View Related

Plesk 12.x / Linux :: Unable To Connect To MySQL Hosts

Jul 18, 2014

After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.

The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !

Though, remote connections are allowed from any host in the settings.

View 3 Replies View Related

Plesk 11.x / Linux :: Parallels Panel - Update PHP And MySQL

May 9, 2014

I am using Parallels panel 11.5.30 Update #44 on CentOS 6.5 (64bit version) located on VPS. What is the easiest way to update:

- PHP 5.3.3 to PHP 5.5.12 (current stable version) and
- MySQL 5.1.73 to MySQL 5.6.18 (current stable version).

Is it possible to update these from Plesk's control panel?

View 7 Replies View Related

Plesk 12.x / Linux :: Can't Change MySQL User Password

Mar 31, 2015

I try to change a mysql user password, but I get an error message:

Fehler: attribute name is invalid: status
Search for related Knowledge Base articles

I'm running12.0.18 Update Nr. 39

View 1 Replies View Related

Plesk 12.x / Linux :: Batch MySql Script Stopped

Oct 2, 2014

I've this terrible problem: on my site I start a script that executes a batch process that imports into the Mysql database a lot of products (texts and images). I'm monitoring the query process from Phpmyadmin>Status and I notice that after some minutes the number of queries decreases from ~900 to ~30, that means that the script is stopped! Then I check the error_log and infact there's this error:

[Thu Oct 02 17:09:34 2014] [warn] [client xxx.xxx.xxx.xxx] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server
[Thu Oct 02 17:09:34 2014] [error] [client xxx.xxx.xxx.xxx] Premature end of script headers: insert_products.php

Some informations:
VPS server: 1 CPU; 40gb; RAM 1GB
OS: CentOS 6.5 (Final)
Plesk version: 12.0.18

What I tried via SSH console:

# /usr/local/psa/admin/bin/php_handlers_control --list
id: display name: version: type: cgi-bin: cli-bin: php.ini:

module 5.3.3 5.3.3 module /usr/bin/php-cgi /etc/php.ini
fastcgi 5.3.3 5.3.3 fastcgi /usr/bin/php-cgi /etc/php.ini
cgi 5.3.3 5.3.3 cgi /usr/bin/php-cgi /etc/php.ini
# /usr/bin/php-cgi -v

[code]....

View 2 Replies View Related

Plesk 12.x / Linux :: MySQL Password Changed During Installation

Oct 15, 2014

Is it possible, that the script changes my admin password for MySQL? I can not connect to my MySQL Server any more.

View 1 Replies View Related

Plesk 11.x / Linux :: MySQL Crashing / Not Loading Correctly

May 14, 2014

I have a Centos 6 server with Heart Internet, who yesterday had an issue with the issue and once back online have been struggling til now getting the mysql service working correctly again and have now refused to provide any further support and redirected me here.

I was following this article here: [URL] ....

I've gotten to point 4. "~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` -A | sed '1iSET FOREIGN_KEY_CHECKS = 0;' > /root/dumpall.sql" however it's saying "got error: 145: table './avenue141_dabs/av_options' is marked as crashed and should be repaired when using LOCK TABLES and any attempts made to get into the DB to repair is giving me "error: 1045: Access denied for user 'root'@'localhost' (using password: NO)

This issue is urgent as we have a few websites on this server which use mysql databases for their website.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved