phpMyAdmin MySQL password reset does not let me login [closed]
location: linuxexchange.com - date: November 29, 2012
Hey and thanks for reading, i am locked out of my own server...
I went to http://localhost/security/ and changed the mysql password for the root user , apparently was not such a good idea because i cant access my phpmyadmin site anymore to configure mysql, WHY?
I've looked online but all they talk about is how to reset your password, I would like to know how I can login into the current phpmyadmin now after i changed the mysql password .
Please help this vulnerable noob be less vulnerable
Bonus: Is there a way to protect the sites on local host with a password
terminal will not let me login as root
location: ubuntuforums.com - date: October 26, 2010
when i attempt logging in as root i get this message...su: Authentication failure. are there any experienced users out there that can help me overcome this problem; i'm trying to install my video drivers and need to login as root before i can attempt this. thanks.
XAMPP MySQL password setting (Can not enter in PHPMYADMIN)
location: linuxexchange.com - date: September 30, 2015
Firstly: I am cannot entering PHPMYADMIN at "localhost:80/phpmyadmin/". Because when I install MySQL server mysql-5.5.36 with Username :root and Password : HamdunSoft . After that when I enter localhost:80/phpmyadmin/ it show me a message like below .
"Error MySQL said: Documentation
1045 - Access denied for user 'root'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server."
Now I want enter my Phpmyadmin though I have setup two MySQL server one in xampp, another mysql-5.5.36. I have searched it in net but the content was not helpful sufficiently. How can I set the password in xampp before login in phpmyadmin .
Another different issue is: XAMPP Apache server was saying : po
MySQL user DB does not have password columns Installing MySQL on OSX
location: linuxexchange.com - date: January 1, 1970
I am trying to change MySql root password.
What I have done is below.
Install MySql-5.7.6 ~ .dmg(Community Server) and workbench.
Turn off the server on OSX System preferences.
Access MySql with console. The command was mysqld_safe --skip-grant
Execute update user set password=password('1111') where user='root'; and got an error message --> ERROR 1054 (42S22): Unknown column 'password' in 'field list'.
FYI, I did use mysql;.
So I did select query on user table and found password column actually does not exist.
It is very weird. Is it possible that original user table does not have password column?
How can I change password, which does not exist?
Thanks for your answer :D
change to config file MySQL my.cnf does not take
location: linuxquestions.com - date: September 27, 2008
I am running ubuntu server at work. I have been trying to make MySQL let me create a larger MEMORY table. I have a table, but when it hits the capacity limit, it fails and crashes.
the setting in my.cnf is max_heap_table_size =
the default is 16777216
i am trying to set it to 52428800
i save the file and restart MySQL and when i do a --verbose --help, it shows being set to the default. The my.cnf does not change. I have even tried with the server was running with
set max_heap_table_size = 52428800
and it takes the query no problem, but when i check, i am back at the defautl 16M.
i am restarting the server after changes in the config file.
would really appreciate any tips on this one, kinda pulling my hair out.
Please help Kubuntu reverts to Zulu time, will not let me correct this!
location: ubuntuforums.com - date: July 1, 2013
You read that correctly, and it's not an allegation that I would make without an investigation first.
At some point, Kubuntu began doing this. Yes, I went through the Settings Date/Time dialog. First I tried the "Set time automatically" option, which it ignored (yes I did hit the Apply button), and then it accepted a manual change of the clock time (not the time zone) until the session expired (always going back to Zulu time (if that's what it's called), or four hours ahead of Eastern Standard Time when the system rebooted).
Somebody on a thread somewhere in the past alluded to the BIOS clock settings, so for what it's worth I checked this. I corrected my BIOS clock by knocking it back four hours, and then I booted into Windows.
In Windows, I surfed the net for about an hour, noting that my Windows time was problem-free throughout that session. But when I rebooted back into Kubuntu, I saw the time change again back to Zulu (on my panel widget), right before my eyes, within
shift does not get me single user mode
location: ubuntuforums.com - date: September 11, 2011
I'm having an issue with sudo, apparently it's parsing a file that I didn't expect it to and it's complaining about multiple definitions. Of course because of the issue I don't have sudo access so I'm trying to get into single user mode to fix.
It seems that holding shift no longer does the trick. Any suggestions?
LightDM will not let me log in.
- date: June 8, 2012
I am having a problem with LightDm and Unity. When I boot up my netbook, I get the lighdm login screen. Then, when I enter my password and click enter, the Lightdm screen goes away, and comes back with the lightdm screen again. When I go and log into the guest account, it works fine. Then, I go to the terminal by clicking CTRL+ALT+F1 and kill lightdm, then type "unity" after I have logged in it gives me this error:
WARNING: no DISPLAY variable set, setting it to :0
pkill:2311 - Operation not permitted
unity-panel-service: no process found
No protocol specified
No protocol specified
compiz (core) - Fatal: Could not open display :0
I'm Stuck. I have no idea if I did anything to break this. I do not know if compiz is the problem, or if it is Unity or Lightdm. If somebody could help it would be greatly appreciated. I would prefer not to have to re-install. I am using a EEE PC 1005HAB with 2gb
MySQL Error: Function Does Not Exist
location: ubuntuforums.com - date: August 17, 2012
I am in the process of moving one of my websites from Centos OS to Ubuntu 12.04. I haven't had any issues with Wordpress or vBulletin, but my custom built website is giving me very strange database query errors:
query failed !SELECT product_model.*,product_detail.product_name,produc t_detail.product_thumb,DATE_FORMAT(product_model_a dd_date ,'%m/%d/%Y')as product_model_add_date,device_model.model_name FROM product_detail inner join product_model on product_detail.product_id=product_model.product_id inner join device_model on product_model.device_model_id=device_model.device_ model_id WHERE (product_model.device_model_id ='183' or supportsChildDevice(product_model.product_model_id ,183) ) AND product_status=1 and status=1 ORDER BY product_model_id DESC:FUNCTION web_elecite.supportsChildDevice does not existquery failed
Funny thing is, it works perfectly OK on Centos but not on Ubuntu. I have spent a bit of time on Google try
Errors on shutting down (does not let shut down)
location: linuxquestions.com - date: March 9, 2014
CentOS 6.5 is installed, and after a few software installation, when I tried to reboot it couldn't and we asked provider to reboot it manually.
I checked 'dmesg' for errors with:
dmesg|grep -i error
Page: 1 2 3 4 5 6 7 8 9 10