Plesk 11.x / Linux :: Mysql 1045 Access Denied With PhpMyAdmin
Nov 2, 2014
One of my users is unable to connect to his database using phpMyAdmin. The query is:
LOAD DATA INFILE '/tmp/phpYXZFfZ' INTO TABLE `count` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '
And mysql reports:
#1045 - Access denied for user '<USERNAME>'@'%' (using password: YES)
The funny part is that I can connect without any problems from a shell like this:
mysql -u <USERNAME> -p<PASSWORD> -D <DATABASE_NAME>.
This server has been recently migrated from plesk9 to plesk11.5, running on a centos6 OS.
View 1 Replies
ADVERTISEMENT
Jul 12, 2009
Im trying to setup a mysql server on my centos vps server. Ive installed mysql server and done chkconfig and the mysql server has started. My problems start when i want to set a mysql root password.
Quote:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
I get an error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"
Which i totally dont understand because why would it want a password when im trying to set the password?
View 6 Replies
View Related
Jan 3, 2015
Plesk: 12.0.18
phpMyAdmin: 4.2.5
When I try to access phpMyAdmin directly from the link: [URL] ....
I get the following error:
Welcome to phpMyAdmin
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: Documentation
Cannot connect: invalid settings.
Retry to connectClick to expand...
View 3 Replies
View Related
Jul 9, 2014
I migrate from plesk 9.5 to another server with plesk 12.0.18, and then outlook and mail default from iphone don't work, but tunderbird and webmail work well.
In outlook when i put the same configuration than tunderbird and i try to send mail out from my domain said this error:
Error del servidor: '554 5.7.1 <244.Red-88-18-221.staticIP.rima-tde.net[88.18.221.244]>: Client host rejected: Access denied
I don't know if outlook is bad configuration but with plesk 9.5 worked well, and now nothing.
I can recive mail but not send.
View 10 Replies
View Related
Sep 19, 2014
today we notice that all subscriptions on Plesk when we access phpmyadmin has access to all databases,it was a Plesk update that can be done this ?
I don't remember to update anything during this days to this happen.
View 1 Replies
View Related
Sep 27, 2014
On the dashboard (intro page) there is the option "Outgoing Mail Control" and there the link "See report". When clicking on "See report" I get a "Warning: Permission denied." error message when being logged in as the full administrator. Is this due to an error in an update or what is going on here?
View 1 Replies
View Related
Nov 9, 2013
when I try to access to my plesk I obtain:
ERROR: PleskFatalException: Unable to connect to database: Access denied for user 'admin'@'localhost' to database 'psa' (auth.php:142).
If I restart with ssh /etc/init.d/psa start and I check plesk_11.5.30_reset_instance_data.log
I note: ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'mysql'.
View 10 Replies
View Related
Sep 10, 2014
I installed the SiteProBuilder (from the www.site.pro page) in extensions of the Parallels Plesk Panel 11.5.30. I installed from .zip file on administrator account of Plesk Panel. The extension SiteBuilder was shown in all administrated subscriptions. On administrator account the extension works properly but when I log into the Plesk Panel as a client of one subscription then extension doesn't start and message is displayed: "Error: access denied".
View 3 Replies
View Related
Nov 20, 2014
I seem to have an error with backing up to my personal FTP repository. I have only just noticed the issue, but i believe it originated when I upgraded Plesk Panel 11 to Plesk Panel 12. I am currently running version 12.0.18 on Cent OS 6.5.
Note whether i check the "Use passive mode" option makes no difference to my problem.Below is what I get from the panel.log under /usr/local/psa/admin/logs
Code:
[2014-11-20 19:49:44] ERR [util_exec] proc_close() failed
[20-Nov-2014 19:49:44 UTC] PleskUtilException: '/usr/local/psa/admin/bin/pmm-ras' '--check-repository' '--dump-storage=ftp://USERNAME@IPADDRESS/MYFTPDIRECTORY/' '--use-ftp-passive-mode' failed with code 121.
stdout:
Transport error: unable to list directory: Curl error: Access denied to remote resource
stderr:
file: /usr/local/psa/admin/plib/Service/Agent/Transport/Local/Exec.php
line: 57
code: 0
trace: #0 /usr/local/psa/admin/plib/Service/Agent/Transport/Local.php(60): Service_Agent_Transport_Local_Exec->process(0, Object(Service_Agent_Command_Exec), Object(Service_Agent_Transport_LocalTransaction))
[code]....
View 8 Replies
View Related
Jul 10, 2015
After setting up a new server on Plesk12, I successfully ran some test mail outs using phpmailer using the SMTP server on this machine
However, there was an issue in creating new local mail accounts in plesk with an error message each time.
Investigating this issue led me to a solution that I should run mail_restore from the Plesk scripts
This cured the problem of setting up new local accounts but outgoing SMTP mail is always failing with 'relay access denied'.
View 1 Replies
View Related
Jun 5, 2009
I've setup a mysql user and assigned a password for it. When I try logging in to it with
Quote:
mysql -u USERNAME -p
and then providing the password I get an error:
Quote:
ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES)
I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not?
I've tried: Restarting mysql
setting new password
changing username
Using mysql server 5.1.34
View 5 Replies
View Related
Oct 25, 2007
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it.
When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message:
ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation
It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View 8 Replies
View Related
Jan 2, 2007
I have apache, php, and mysql setup on CentOS 4.4. I have phpMyAdmin running perfectly in a folder in /var/www/html/phpMyAdmin. I can access phpMyAdmin and use it perfectly. I downloaded Cacti which is a server monitoring application written in php, nothing special. I untar the file and it creates a folder, I simply do a mv command from /home/sys/cacti to /etc/www/html/cacti. Then when I open my browser and attempt to access: [url]I am getting a Access Denied error. It makes no sense though, I have verified the permissions of the files and folders, all good.
The group owner and owner are root, the files are all -rw-r--r-- and the folders are drwxr-xr-x.
View 9 Replies
View Related
Feb 15, 2015
in last two day we have problem with plesk on windows server 2008 r2 plesk version is 12.we have Access is denied error in some part of plesk like: can not add email address.can not edit email address..can not active on suspend domain..i Conant support team and they are solve problem but after on day. problem came back.in attachment i attach error log file and screenshot on errors.
View 3 Replies
View Related
Mar 16, 2015
A few day ago when i access Windows plesk i receive error Access Denied. [URL]..... Even i made these steps i still receiving Access Denied when i access. I tried use PLesk REconfigurator, put psaadm permissons on all C:, update plesk, windows and still having this issue.
View 3 Replies
View Related
Apr 6, 2015
Login Plesk 12 In Error :
Operation failed
The operation you were performing failed. You can retry the operation with or without changing its parameters. You may also want to report this problem to our support.
Error show :
Access is denied.
---------------------- Debug Info -------------------------------
Windows 2012 and Mssql 2012 .
View 4 Replies
View Related
May 25, 2014
When I tried access parallels plesk panel 11.5 ... It's show windows password, if i enter Administrator credentials i see login of parallels, if i cancell i receive this error: "401 - Unauthorized: Access is denied due to invalid credentials."
I also tried use reconfigurator but i receive this error on attach 2...
View 2 Replies
View Related
Jul 6, 2015
When trying to delete A client I get the following error:
Internal error: Access is denied.
Message Access is denied.
File Hierarchical.php
Line 105
Type Exception
I'm on plesk 12.0.18 Update #53 and have run the plesk reconfigurator to check for permissions issues.
View 1 Replies
View Related
Sep 22, 2012
I have a problem with my plesk v11, when i create a new subdomain and upload my asp.net application to that and make a request to view my web page it get Server Error 401 :
401 - Unauthorized: Access is denied due to invalid credentials.
You do not have permission to view this directory or page using the credentials that you supplied.
But my main web site have not any problem and works fine, my changes that didn't work :
1) change in web.config file :
<authentication mode="None">
</authentication>
2) change in web config file :
<authorization>
<allow users="?"/>
</authorization>
Another question that i have is this happens because the Plesk's default permission assigning to the main domain so the users can view content without problem, but the permission isnt assign to the created subdomains ?
If this is the problem, how can i fix it so my users can see the content with our Windows Authentication or Forms authentication or anything else?
this is my domain name : www.senatex.ir
and this is my sub domain : nerkh.senatex.ir
Also parallels default host files not have any problems, for example : content.senatex.ir
View 1 Replies
View Related
Apr 9, 2015
Recently i installed the latest Multiple PHP functionality for Plesk and assigned PHP version 5.6 to a subdomain (for example demo.mywebsite.com) and i installed a Wordpress. So i thought i would try something out by installing a custom standalone version of phpmyadmin (version 4.4.1.1) and when i load the setup i ran into the following issue on the index.php page:
Code:
Warning in ./libraries/session.inc.php#101
session_start(): open(/var/lib/php/sessions/sess_dubv0rqju6bejfplkgcsl98qsonviukg, O_RDWR) failed: No such file or directory (2)
Backtrace
./libraries/session.inc.php#101: session_start()
./libraries/common.inc.php#352: require(./libraries/session.inc.php)
./phpinfo.php#12: require_once(./libraries/common.inc.php)
note 1. Due to privacy i have called domain 'demo.mywesite.com' and subfolder 'root'
[code]....
View 5 Replies
View Related
Jan 22, 2015
Where I can get full country list ? I need it to my new site and there missing lot of country in the list. I have 109 country but world have more ....
List must be like this:
(1, 'af', 'Afghanistan'),
(2, 'dz', 'Algeria'),
(3, 'ar', 'Argentina'),
(4, 'au', 'Australia'),
Have search on internet but not find good sites!
View 2 Replies
View Related
Dec 6, 2014
I made a backup of my website with plesk backup manager on an external FTP, now I want to restore this backup on a new server which isn't using plesk, for test purposes. I've downloaded the backup (which is in .tar) on my PC, and extracted all files firstly from the general .tar archive, then the user_data from .tgz. Then to extract all the databases (they were in a folder "databases" after I've extracted the general .tar file), I extracted them from database_name_145536536.tgz, then from database_name_145536536.tar, so that now I've a series of "database_name_145536536" files. (145536536 are some example numbers).
I'm interested in restoring both files and mysql databases.
To restore the files, I can simply use the extracted files from the user_data archive.
To restore the mysql databases, I tried to do "mysql -p -u username database_name < file" and everything seemed to work fine.
Is this process ok? Is it 100% safe and sure or I could face some bugs?
View 8 Replies
View Related
Jan 28, 2015
CentOS 6.6
Plesk 12.0.18
64-bit
At some point, not sure when, PHPMyAdmin's (as accessed through the admin panel by clicking on a customer, manage hosting, databases, etc) permissions have changed such that I cannot view, edit or add MySQL routines/procedures. This appears to have occurred system-wide, though I have not checked every database on the server.
Is there a fix to get the permissions set so that I can make these changes again?
View 3 Replies
View Related
Jul 2, 2015
We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
View 4 Replies
View Related
Feb 15, 2015
SOCentOS 6.6 (Final)
Plesk12.0.18 Actualización #35
I can not sign with any FTP account.
/var/log/messages:
FTP session opened.
unable to open TransferLog '/usr/local/psa/var/log/xferlog': Too many levels of symbolic links
chroot to '/var/www/vhosts/domain.com' failed for user 'user': Permission denied
error: unable to set DefaultRoot directory
FTP session closed.
View 5 Replies
View Related
Feb 12, 2015
Mail isn't leaving the queue, it's returning this error
Feb 12 23:12:01 XXXX postfix-local[64360]: System error .qmail: Permission denied
Feb 12 23:12:01 XXXX postfix-local[64360]: Wrong permissions for .qmail
All the files within /var/qmail/ are set to the user and group "popuser", and have the nessacery rwx permissions for the user/group.
The OS is CentOS.
View 5 Replies
View Related
Jan 3, 2015
i've uninstalled nginx and php-fm from plesk panel.but phpmyadmin info still showing it is running on nginx 1.6 and while uploading sql file i'm getting 503 gateway error.
View 3 Replies
View Related
Sep 9, 2014
I deleted Nginx web server and reverse proxy support from Plesk. There is no this service on server, but I still see on the web server informations like nginx/1.6.0 at phpmyadmin page.
View 6 Replies
View Related
Feb 9, 2015
I'm on a VPS with Ubuntu 14.04 and Plesk 12 Web Admin Edition. I can't import a large (20 MB zipped) database dump to phpmyadmin because there is a 2MB file size limit. I suppose I have to change the server-wide PHP configuration (if I change the PHP settings for the domain nothing happens). Is there a way to change the global PHP settings via the Plesk panel?
View 2 Replies
View Related
