I need to get an old MySQL Client(4.1)to connect to an even older MySQL Server (3.23).The goal is to do a Java/JDBC connect to the old Linux/MySQL 3.23 database, in order to update text information for a Lucene search (which will also run on linuxdev2). The problem is that I can't connect to the Linux/MySQL 3.23 server from a remote Linux/MySql 4.1 client. I can't connect from JDBC; I can't connect from "mysql":
mysql -uSOMEUSER -pSOMEPASSWORD mysql => OK
REMOTE (from linuxdev2):
mysql -uSOMEUSER -pSOMEPASSWORD -hintranet mysql => FAILS:
ERROR 1045 (00000): Access denied for user: 'SOMEUSER@linuxdev2' (Using password: YES)
for some reason root lost grant privileges and I can't get it back. The user got grant_priv = 'Y' in the usertable. I've tried to reset all the priviliges to the user by killing MySQL process and started up again without grant options with no luck. I've also tried lots of other things but can't seem to get it work. Here is what I get: Quote:
[root@xxxxxxxxx mysqldba]# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.0.77 Source distribution
I have been following this guide to install Apache, PHP & mysql - [URL]. When I get up to the step 'mysql -u root' I get given this error: Code: tom@tom-laptop:~$ mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) How do I overcome this?
I am not sure if this is the correct forum to post this as I have usually been able to find the answers from other peoples threads.The error I receive is below.(changed "at" as can't post links)"#1045 - Access denied for user 'root' at 'localhost' (using password: NO)" Not entirely sure what has happened here. I have had this server running for a long time and today it seems to have spat it's dummy out!I have checked the config.inc.php and the controluser and controlpass are entered correctly so the error saying a password is not being usPHP Code:Thisis needed for cookie based authentication to encrypt password incookie
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ? b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user) c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
Cannot seem to use my mysql password, keep getting the error "Access denied for user 'root'@'localhost' (using password: YES)" So I tried checking my password using mysql -u root -p and I get the same error as above. I've tried accessing mysql with skip grant tables disabling the need for a password so I could reset my root password. After going through the necessary steps I still get the error above when typing my password in for mysql.
I am pulling my hair out once again after trying for over 15 months off and on to get a tv tuner working under linux. I have just received my new tuner card which I thought was supposed to be easy to run, a HVR-950Q, no luck yet. But first I am trying to use something called mysql (new to me), for mythtv and [I] keep getting
# mysqladmin -u root password ma mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)
I have got a RHEL 5.6 server configured to authenticate via a Windows 2008 domain controller via LDAPS.Everything is working fine, except from the following: When I create a new user in Active directory and check the option "user must change password at next logon", the new user cannot logon and gets an "access denied" message. In /var/log/secure, I find the following:
Mar 1 14:43:21 cpssvn10 sshd: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=192.168.3.12 user=testuser2 Mar 1 14:43:21 cpssvn10 sshd: pam_ldap: error trying to bind as user "CN=CPSS Testuser 2,OU=IBM,DC=cpss,DC=smarterplatform,DC=com" (Invalid credentials) Mar 1 14:43:23 cpssvn10 sshd: Failed password for testuser2 from 192.168.3.12 port 4583 ssh2
As soon as I uncheck the "user must change ..." option, the user can log on without problems. Also password change via the passwd command works.
i trying to create file in /usr/local from below command"sudo df | grep /dev > dev_string.txt"First it asked for sudo password. I enterd sudo password. but I was not able to create the file dev_string.txt .Next time onwards it not asking sudo password also.the below execution flow
I execute: mysql -u root -p and asks for a password after I put the password and ENTER the following error! ERROR 1040 (00000): Too many connections Can you tell me where is the folder of mysql? For me to edit the my.cnf?
I keep receiving the error message in the title above whenry to enterebmin.abc.com/webmin. I'm on Ubuntu 9.10. Other errors I'll receive are "You do not have access to any Webmin modules". Wondering if anyone knew what settings our permissions on files I could change to avoid these error
I am trying to set up remote login via SSH from my Mac to an Ubuntu desktop. Here is the error i am getting:
Code: Permission denied (publickey,password). I'll give background:
- Both computers are on the same network - I'm not using the default port 22 - I have successfully logged in using password authentication, so it isn't a firewall/iptables issue i don't think. I've already worked through those issues! - I haven't set up any tcp wrappers on the server yet, so nothing is being denied - I believe the server sshd_config file is setup correctly. I can post it if needed.
Here's debugging info: bash-3.2$ ssh firstname.lastname@example.org -v OpenSSH_5.2p1, OpenSSL 0.9.7l 28 Sep 2006 debug1: Reading configuration data /etc/ssh_config debug1: Connecting to xxx.xxx.x.x [xxx.xxx.x.x] port xx. debug1: fd 3 clearing O_NONBLOCK debug1: Connection established. debug1: identity file /Users/localuser/.ssh/id_rsa type 1 [Code]....
I cannot install files from source (tar.bz, tar.bz2, tar.gz, etc) my latest attempt began at tuxfiles. following the 'tutorial', if you will, I managed to unpack the files; but when it came to the ./configure step, I got the following error: zsh: no such file or directory: ./configure
Here I figured different distros, slight variances, so instead I tried putting a space in the command (./ configure), and got this error. zsh: permission denied: ./
So finally I tried both ./configure and ./ configure as su and I still got the same errors... this is the same problem that I've always had when installing from source. I am using Fedora 12.
Firefox seems to suddenly dislike one of the groups i belong too, whenever i try to access it I get the following message,
Database Error: INSERT command denied to user 'usingle_210259_1'@'linweb14.atlas.pipex.net' for table 'smf_log_online' File: /websites/LinuxPackage02/si/ng/le/singlewithkids.co.uk/public_html/forum/Sources/Subs.php Line: 2602
Is this a server error, or is it my system? I have tried using a different theme but I still get the same error.I'm using the gnome classic theme ATM.
I have same problem with *.bin files.When I try to install software from *.bin file I see error:
Code: [andrew@notebook Programming]$ ./installbuilder-qt-professional-6.3.0-linux-x64-installer.bin bash: ./installbuilder-qt-professional-6.3.0-linux-x64-installer.bin: Access denied [andrew@notebook Programming]$ When I run command ls -la I see this:
Code: [andrew@notebook Programming]$ ls -la installbuilder-qt-professional-6.3.0-linux-x64-installer.bin -rwxrwxrwx. 1 andrew andrew 82624164 ÐÐ¿Ñ 4 16:39 installbuilder-qt-professional-6.3.0-linux-x64-installer.bin [andrew@notebook Programming]$ This error exist if I try to install this application with root access. What I mast do for fix this error?
P.S. I have Fedora 12 x86_64 on my notebook ASUS M51Sn.
I am having difficulties with Pure-FTPD. I had it working at one time. I recently had to reinstall Ubuntu 10.10 because pure-ftpd stopped working for some reason and now I have a fresh install but pure-ftpd still does not work. This is what I did to install it.
Sudo apt-get install pure-ftpd
Using the Ubuntu Spftware Center I installed PureAdmin. I then create a virtual user. Then in the terminal entered the following:
I read somewhere that this could be a filezilla issue and to fix it I need to use active mode and use the filezilla external address [URL]... Of course I did this and the filezilla solution did not work this time. I am fairly sure it is a server issue this time.
running Ubuntu 10.10 and mozilla and seamonkey... Tried to access a website: [URL] and got the error: The page cannot be displayed You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed. Please try the following: Contact the Web site administrator if you believe this directory should allow execute access. HTTP Error 403.1 - Forbidden: Execute access is denied. Internet Information Services (IIS)
I just built an AMD Phenom II Six Core with 4 Gigs Ram a 160Gib / and swap, and (2) Two Tb mirror for Raid (data storage) I had been using DMRAID in the deprecated box but this box has MDADM v3.1.4 - 31st August 2010 from source (on MDADM wikipedia).
I have no permission problems with using the raid and dmraid is un-installed. The raid is working perfectly and is mounted in my fstab with ext4 defaults 0 2 as my options.
I have two exports /media/raid/Test /test
Both show IP and subnet on the showmount -e for the server. I can mount the test just fine on the server. I cannot, however, mount the /media/raid/Test error: mount.nfs: access denied by server while mounting hostname:/media/raid/Test Using dmraid I am able to have the deprecated box export and mount nfs shares from the raid but using MDADM on the new computer, I cannot. I get similar results with pointing MYSQL's data folder to a location on the "/media/raid/Database" (even with apparmor entries).
I mount a partition to a directory and ls -liah tells me that everyone has read/write/execute permissions on the whole thing, but I try to save a file into the partition and I get an access denied error. First of all this doesn't make sense because ls is telling me I do have access.
Then it gets weirder. I run sudo chown -R me:me directory. The command exits without error, but then when I go and look at the directory again with ls, it still shows up as owned by root and I still have the same problem. This is particularly strange because I am still able to change permissions normally in the operating system filesystem. It just won't work on the mounted partition.