| View previous topic :: View next topic |
| Author |
Message |
kozaap2p
-
Joined: 29 Sep 2004
Posts: 2
Location: Sumwhere i belong
|
 Posted: Wed Nov 10, 2004 11:39 pm Post subject: MySQL isnt working anymore!! |
 |
|
Ok listen up, did some tutors, and everything was fine. i had a forum and bla bla bla... so i shut down the tool for MySQL (MySQL Admin) restarted my computer.. and voila, mySQL dont work anymore. I tried to mange some things with PhpMyAdmin, but it was hopeless, it didnt worked neither. Ive tried severalthings, even searching on forums and google. So now, who can help me with this. My.ini is perfect, nothing wrong with it... Just help me pleaz
Tnx in advance
_________________
Free you mind and your *ss will folow |
|
| Back to top |
   |
 |
vhanla
-
Joined: 11 Nov 2004
Posts: 1
|
| Posted: Thu Nov 11, 2004 10:09 pm Post subject: Re: MySQL isnt working anymore!! |
|
|
Hi!, Listen:
I did the same thing, but MySQL did not restarted my PC, so it couldn't work anymore, but I searched in the directory where it is installed, so I find the file called "mysql_opt" or something like that, right now I can't remember the exact name, but it was with "opt" including...
I executed that file and it run a console window and after 3 seconds it disappeard and loading itself into memory...
Just one thing.... It is a win32 MySQL what i was using!!!! |
|
| Back to top |
|
|
snamla
-
Joined: 28 Oct 2004
Posts: 6
|
| Posted: Tue Nov 30, 2004 9:42 am Post subject: |
|
|
| Try running winmysqladmin.exe (included in the MySQL Server package), it will automatically run the next time you open your OS (Windows). winmysqladmin.exe will just sit down in your tray bar. Have not tried other OS though. |
|
| Back to top |
|
|
hao32
-
Joined: 06 Dec 2004
Posts: 4
|
| Posted: Mon Dec 06, 2004 4:00 am Post subject: |
|
|
I think you had beter reinstall everything .
_________________
hao32 |
|
| Back to top |
 |
|
leawildcat
-
Joined: 04 Dec 2004
Posts: 9
Location: Texas
|
| Posted: Mon Dec 06, 2004 12:32 pm Post subject: Ditto |
|
|
I had the same problem you had. Everything was working last night and then I rebooted and went to work on my tutorial today and red light *sighs*
I fixed it though :)
Did you follow the tutorial where it said to remove the anonymous users?
If you did that's the problem, at least it was for me. I was tyring to get the mysqladmin to work on the command prompt. It kept telling me an error about OBDC@localhost.com.
Open a command prompt and negotiate your way to your mysql\bin folder.
Type mysqld -u root -p.
Enter your password if it asks.
Once you get the mysql> prompt type in
grant usage on *.* to 'OBDC'@'localhost.com';
then type
FLUSH PRIVILEGES
to check it type
select user,host,password mysql.user
You should get a table with 2 listings now showing the root and the OBDC. If it doesn't work let me know, I might have missed typed something.
Now if I can just get phpMyAdmin to work. |
|
| Back to top |
|
|
DaytonDaytona
-
Joined: 07 Dec 2004
Posts: 1
|
| Posted: Sun Dec 19, 2004 8:14 pm Post subject: |
|
|
| Quote: | You should get a table with 2 listings now showing the root and the OBDC. If it doesn't work let me know, I might have missed typed something.
Now if I can just get phpMyAdmin to work. |
I'm suffering the same problem.
If you can get in as root or ODBC, using mysql or mysqladmin, you should be able to edit your config.inc.php in the phpMyAdmin directory and get it running again.
Change the lines that say:
$cfg['Servers'] [$i] ['user'] = 'whateveryouput';
$cfg['Servers'] [$i] ['password'] = 'your password';
back to:
$cfg['Servers'] [$i] ['user'] = 'root' ;
$cfg['Servers'] [$i] ['password'] = ' ' ;
Save then try to reconnect to phpMyAdmin.
I can't promise 100%, because I've got other issues I'm fighting too, but it seemed to work for me until I blew it up again doing something else.
Hope it helps. |
|
| Back to top |
|
|
GustavoDL
-
Joined: 08 Jul 2004
Posts: 16
Location: Malaga (Spain)
|
| Posted: Mon Dec 20, 2004 1:25 am Post subject: MySQL as System Service (win) |
|
|
Okay, the problem is that MySQL isn't running as a Service.
To re-run execute <MySQL_path>\bin\mysqld.exe
To have WinMySQLMyAdmin runing in taskbar again execute <MySQL_path>\bin\winmysqladmin.exe
Closing mysqladmin doesn't stops mysql service
(services only on NT systems (linux use daemons }:-D ))
_________________
Think as WAN, act as LAN
Piensa en WAN, actua en LAN |
|
| Back to top |
|
|
|
