I'm running an Ubuntu 9.04 Minimal server and trying to get MySQL to work correctly. But when I try to access MySQL with the root user it doesn't want to.
Code:
mysql -u root -p
Enter password:
[code]....
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 :-
Quote:
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)'
Query :-
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)
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
I have a question in regards to enabling root remote access to the server.I am trying to use the mysql workbenchit kicks back an error saying "Access denied for user 'root'@'10.x.x.x' (using password: YES)" But I am able to login locally on the server.How do I enable root to long on remotely from any workstation?
View 3 Replies View RelatedI've tried every manual there is for creating new MySQL users ... but without success.
I keep getting
Code:
ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES) even though I just created it with all privileges ... WITH a password that I DO remember .
Fortunately I still have access via the MySQL root user (so I try not to disturb that user, because I have had computers with THAT account not accessible as well - even WITH resetting the password via skip-grant-tables).
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
View 2 Replies View RelatedI did something silly and changed my root user access for mysql access to Any from localhost using webmin. I get an access dented when i try to open up the mysql editing page on webmin. Can any of you tell me if there is a way to change it back to hosts=localhost I am using webmin 1.5.30 on Centos 5.5. I am hoping I can change it by command line or if I can access the config files and change it that way?
View 2 Replies View RelatedI have forgotten my root password for MySQL, what can I do to recover it, I've found a few guides but they don't work on the newer versions of Ubuntu.I am running on Ubuntu 10.04 server so MySQL is an upstart job so the methods I've seen with launching it without the access checks haven't worked for me
View 4 Replies View RelatedI have forgotton my root password for mysql. I followed some instructions on a website and now I am not sure what i have done?Basically, when I now try and start mysql I get a notification that i have converted the init script to an upstart. I dont know what this means.
Since the script you are attempting to invoke has been converted to an Upstart job, you may also use the start( utility, e.g. start mysql mysql start/running, process 20301.
Using 11.04, and just installed mysql 5.1.54 using synaptic
I was following the instructions here and the installation when fine,
except that I never got a screen to set the root password.
When I try to set the password using these instructions, following either
"If you have never set a root password for MySQL" $ mysqladmin -u root password NEWPASSWORD
OR, since the first method failed me, then: "However, if you want to change (or update) a root password, then you need to use following command" $ mysqladmin -u root -p'oldpassword' password newpass
Either way, it fails. Question:
1) why am I not being prompted to set a root password during installation?
2) what can I do now to fix this??
I am trying to learn Mysql, so don't presume I know anything about command syntax (cookbook instructions) For example, the first command above,I tried with with NEWPASSWORD in quotes, and then without. Likewise for the second command.
I forgot my root password for mysql, and after some searching I found several solutions to fix it. But none of them seem to work.I tried this article http://ubuntu.flowconsult.at/en/mysq...root-password/ with starting mysql with the --skip-grant-tables option. The problem is that nothing happens, it just hangs.Also tried the the --init-file option, that one runs fine, at least it returned to the command line. But the sql query in the file to which it point doesnt seem to do anything. The password wasn't changed to the one I specified in the sql file.Any idea what could be going on here, and how I could fix it?
View 3 Replies View RelatedI set up mod_proxy in order to get rid of :8080 now I cant access phpmyadmin through the browser. what is the quickest way to turn off mod_proxy and access phpmyadmin? I would like to optimize the tables and back up the sql file. I just need to turn it on for a bit, and then enable mod_proxy again.Right now, if I got to localhost/phpmyadmin, it redirects to the main application.
I have used a2enmod, and added
sudo a2enmod proxy
sudo a2enmod proxy_http
sudo a2enmod proxy_ajp
[Code]...
When you access mysql within the same Apache server (same ip address) via php, do you need to GRANT user ip in order to login to mysql?
Where are the log files for php, mysql etc?
I erased Windows a week ago and is loving Ubuntu 10.04 (which changed to xubuntu after installing Qimo for Kids??) ever since. Now I want to get coding again and PHP is working fine, but I can't access mysql!?I followed a ton of guides, completely removed, reinstalled etc. Nothing works.Here some stuff that might be interresting. I can't remember the "ls" and "awk" and "grep" commands to use, so please guide me if you need more info.
sudo mysql status
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
sudo update-rc.d mysql defaults
update-rc.d: warning: /etc/init.d/mysql missing LSB information
[code]...
We started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
One server is a dedicated MySQL server. After upgrading that one to Ubuntu 10.04 (from an ancient Suse 9.2), both servers are running Ubuntu 10.04 LTS.I have another server that I use to administer the database server via phpMyAdmin. However since the upgrade it is not able to connect. I get an error #1130 Cannot log in to the MySQL server. The same happens if I try to connect remotely from the command line with: mysql -u root -h 129.79.137.121 -pI'm not sure if this is an iptables/ports problem or a configuration problem on the MySQL end or something else entirely.I've searched and tried the suggestions I've found in various places but none seems to have fixed it.
View 2 Replies View RelatedI configured the server freeradius with mysql and I think I configured well freeradius and mysql but when I m testing my configuration with:
radtest nezar azerty 127.0.0.1 0 azerty1234
I have always:
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=108, length=20
I am up and running. Symptom: webapp/servlet deployed to Tomcat, utilizes JDBC driver for MySQL connectivity. Upon launching application in browser and performing action requiring database interaction, exception thrown, server log:
[Code]...
I have Virtualbox setup
WinXP Host
Ubuntu 10.04 is the guest
Mysql is installed in ubuntu and it works fine in the guest (ubuntu)
Internet works fine in the host and the guest. Bridged Network.
Now, here is the thing... i want to access mysql from my host to load some data into it.
how do i access mysql from my host Win XP?
I can not access my MySQL database from any remote host on my home network, I keep getting "Access denied for user 'dbuser'@'192.168.1.10' (using password: YES)"
From what I've read this seems to be a permission problem, I tried
'dbuser'@localhost';
'dbuser'@'%';
'dbuser'@'192.168.1.10';
and between each change of permission, I've flushed privileges.
My Linux server which is running my company website have been hacked. Today I saw a number of clients (customers) with some fun characters entries on my database. Access denial on really clients.
View 2 Replies View RelatedI am a Newbie to Server platform. Just installed Ubuntu 9.04 server, As my Lappy not supporting OEL 4. I was shocked to see that there is no GUI. Anyhow, in that it is showing to Login. I enter the Username and password which was created during Installation on Ubuntu server. It was fine. How to goto Root?
I typed su - root and entered password
Says Authentication failure.
How can I overcome this? While Installation where ever it asks for a password I use the same one.
I was trying to install MySQLbd (a module for python to connect and access MySQL) I followed these steps for installation[URL].. but while I am getting some installation errors. When I try to run $ python set.py build I am getting the following errors (I removed few errors as I can post more than 10000 characters here)
[Code]...
I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
I have installed mysql-server, but i have no access. I have set the password during installation process.
Used command:
mysql -u root -p
error message:
[code]....
I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
I was using the latest stable release of Debian, dual-booted alongside Windows Vista, with the GNOME desktop, installed via netinst, trying to build and install a library that I knew and trusted, when suddenly I couldn't open the Root Terminal. I clicked the link (in Applications->Accessories (I think, whatever the top one is)->Root Terminal), and in the taskbar I saw an item that said "Starting Root Terminal". A few seconds later, that went away, but the terminal still wasn't open. I tried the regular user terminal, to see the same thing happen. Unsure of what was happening, I tried restarting my computer, since that's always the first step you should take in computer problems.
When I restarted, GNOME wouldn't start. The screen would flash a bit for a few seconds, then a dialog box would appear over a background of static that said "The greeter application is crashing. Attempting another one...".t would then go back to the DOS-style kernel, wait a second, and then the same thing would happen. After several of that, I would get a blue screen which said something to the effect of "It has been detected that the desktop environment has crashed six times in the past 30 seconds.
Waiting two minutes before trying again." When it did that, I tried logging in as root to assess the problem. I gave it the correct password, but it said that it was an incorrect login. After several tries (to ensure I didn't mistype the password), I logged in as myself. Same problem. I tried the su command, with the correct password, and it said it couldn't authorise it.
After a lengthy conversation with a friend of mine who was very good with computers, he basically summarised that he had no clue, but that his best guess would be a virus. Upon running the Linux installer, I found the Repair option. Not being particularly familiar with Linux, I used it simply to backup my important files onto a flash drive. I then tried running the Install option, in an attempt to simply write over my existing Linux and make it new again. The installer, however, consistently froze up when trying to start the partitioner, on the "Checking disks..." stage. I figured it was a problem with my partition. In my naivete, I simply used the Windows tools to clear that partition... It destroyed GRUB too, so I couldn't run any OS. I figured my computer was pretty well screwed, and at that point just decided to bring it into the shop and have them completely wipe it.
my computer was backed up onto an external hard driven I brought it back, I reinstalled Windows. Upon restart, it said that it was still looking for GRUB, which made no sense to me. After messing around with it a bit, I decided to just reinstall Linux too. To my lack of surprise, that fixed the problem. Both OS' now ran just fine. The first thing I did on Debian was to install the Clam Anti-Virus, which I understood to be one of the best Linux anti-viruses. However, within about 10 hours, got the same problem as originally. I wasn't doing any of the same things, and between the lack of consistency in activities and the fact that I had an anti-virus running,figured it wasn't a virus. Not knowing what to do, I just left it and have been using Windows since.
I installed MySQL and I started playing around (first time using a database).
I eventually ended up deleting the root user. And now I can't log back in.
I tried
Code:
And I was prompted to set a new root password, which I did. However...
Code:
I want to do a fresh install of MySQL.
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.