Anyone fancy helping me MySQL
- Started
- Last post
- 20 Responses
- Dancer
Stupidresponse gave me some help last night. But I am still finding it hard to access Myphpadmin.
Anyone fancy giving me a hand resetting my password?
I have read and re-read this: http://dev.mysql.com/doc/refman/…
But get stuck at the first line ("locate .pid file")
Anyone board and looking for a distraction??
;)
- moth0
This might sound obvious - but have you just tried uninstalling and starting over?
- moth0
I read the other thread earlier and wondered if you were still stuck...
- Dancer0
haha. Hi moth.
Well over the weekend I had abit of time and the missus is away so I decided to relook at PHP and installing wordpress/expression engine or something similar and started off by setting a password for my PHPmyAdmin – that is about as far as I got because I could not gain access after that.I can always reinstall it but I can predict that when I try to set a password again I will run into the same issue.
- moth0
Are you sure it worked?
In other words - try removing the password from phpMyAdmin and try again to access it.Also ensure the username is 'root', and not blank.
- maximillion_0
Dancer - is this just for MySQL? if so use the community edition of SQLyog - A MYSQL GUI
http://www.webyog.com/en/downloa… - its much more intuitive than phpmyadmin and isnt html based
- Dancer0
Is it me or am I fucking stupid?
I have trawled the internet for a solution and found loads but have no idea how to implement them. cannot even start and stop the server via terminal plus the start/stop button in my prefs pansl is bust as well
- No. you're not a techie, so you're allowed to be flummoxed by things like this.
I'd do as moth says - start again.detritus - (nngh) over - if you've data in there already, do a file back up of the mysql bit, and re-install.
Not ideal, but it'll work.detritus - so reinstall mysql you say? or phpmyadminDancer
- no data.
so will this reset the password?Dancer
- No. you're not a techie, so you're allowed to be flummoxed by things like this.
- detritus0
There's no data to lose? Honestly, I'd just start from scratch then. I'm worried how your 'local install' could be 'hacked' though? But as you're on Mac, it's alien territory for me, I'm afraid. Sorry.
- Dancer0
so reintsall phpmyadmin you say?
- detritus0
proviso - I'm unfamiliar with your setup.
If it were me, and I genuinely had reason to suspect hacking, I'd copy out the 'htdocs' folder, with all my php site files in, then uninstall the whole damn local shebang - server, mysql, everything. Then, I'd try and work out how to secure the install before reinstalling. After which I'd copy the php working files back to the relevant folder.
My experience only spans as far as my Xampp install, which I feel quite confident with, and uploading this stuff to my online server, so perhaps I should just shut up and you should wait for a mac head to come along.
Might help if you spell out exactly what sort of local server you're running.
- ender790
so, let me get this straight. you are trying to run a local server on your mac for development purposes? how did you install your server to begin with?
- Dancer0
Apache I believe.
I am gonna back up my work to date and run diskwarrior and fix permissions, etc... I am then going to re-intsall phpmyadmin or perhaps have a look at the one Max suggested...
Any mac heads know of a way to see if you have been hacked?
- Dancer0
Hi enders, Server comes on the mac already just have to switch it on
- ender790
if you're just using it for development on your local machine, check this out: http://www.mamp.info/en/mamp.htm…
it's pretty easy to install and use. i've got it set up on my mac at work (for when i have free time). i'm not a mac guy, and i didn't find it difficult to set up.
- moth0
You might be better off with Xampp Dancer rather than trying to maintain that setup yourself.
http://www.apachefriends.org/en/…
Otherwise, reinstall MySQL and PHPMyAdmin and stay off the web until you have it tied down.
Furthermore, I think entropy source deployment distros.... in otherwords, you might have unwittingly turned your Mac in to a webserver rather than a closed development box.
- moth0
Also, I think you should (and it's only fair) start another thread called "MAC HACKED".
- Dancer0
so.
which one then? Mamp or Xampp?Also anyone have any sure fire solutions of uninstalling this Mysql and admin?