problems when restarting mysql

 
Post new topic   Reply to topic    Aprelium Forum Index -> General Questions
View previous topic :: View next topic  
Author Message
The Clay Camel
-


Joined: 08 Apr 2005
Posts: 4

PostPosted: Fri Apr 08, 2005 9:05 pm    Post subject: problems when restarting mysql Reply with quote

Behind a router I do have a lan and one of the win98 pc's works as the web server.

I do have mysql, phpmyadmin and a small phorum. All set up as in the tutorial on this site (aprelium) and all works fine until ...

The pc (the server) need to start up again (a bit unstabile power supply, small children turning of the pc, windows crashes and so on)

When starting up win 98 and winmysqladmin - only red light.

Only thing to do is to reinstall mysql, configure it, and copy my db forum into the data folder, and everything is ok again.

Also find out if I refresh / restart mysql with phpmyadmin I get the access denied messages, and that I don't have privilegium to shut down the server using winmysqladmin.

In config.inc.php i use

$cfg['PmaAbsoluteUri'] = 'http://192.168.2.73/phpMyAdmin/';
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
and user /password same as in the privilegum in configuration for mysql

Anyone who knows what I'm doing wrong ?
Back to top View user's profile Send private message Visit poster's website
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Fri Apr 08, 2005 9:32 pm    Post subject: Reply with quote

You should start up MySQL using mysqld-opt.exe once you get it properly
installed from the WinMySQLSAdmin.exe program then it will work. LateR!

Need some help setting up MySQL ?
My MSN: msn@trustabyss.com
Back to top View user's profile Send private message Visit poster's website
The Clay Camel
-


Joined: 08 Apr 2005
Posts: 4

PostPosted: Fri Apr 08, 2005 11:48 pm    Post subject: Reply with quote

I have tried to start with:
Start-Run-WinMySqlAdmin.exe .. only red light and no db's

I have tried to start with:
Start-Run-MySqld-opt.exe also
Start-Run-MySqld-opt.exe -h localhost -u My_user_name -p .... only red light and no db's
and variants with -pPass_Word .... but.......
also tried to have the -h -u -p parameters in the my.ini file but ...

Something I'm not doing right when I start / restart MySql I guess
Back to top View user's profile Send private message Visit poster's website
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA

PostPosted: Sat Apr 09, 2005 1:48 am    Post subject: Reply with quote

Make sure your Firewall isn't blocking access to the MySQL server. LateR!
Back to top View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> General Questions All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group