redarrow Posted October 2, 2007 Share Posted October 2, 2007 Advance thank you. i have setup a webserver on it own, and a database mysql server on it own, i need to no is it possable for me to get the web server to talk to the internal mysql server via it own made up ip. so if some one wanted to add somethink to the databse via the web server and the web server passing it to the ip 192.168.0.10 is that possable cheers. been on this all day i get the error websever not allowed to connect to ip 192.168.0.10 port 10036 dont no why. so the database server got the ip off 192.168.0.10 but dosent work even setting the router to ip and same port fowarding. Link to comment https://forums.phpfreaks.com/topic/71550-need-to-no-about-a-setup-of-my-mysql-and-php/ Share on other sites More sharing options...
redarrow Posted October 2, 2007 Author Share Posted October 2, 2007 ok according to mysql you got to bind the mysql server to the root user example GRANT ALL PRIVILEGES ON *.* TO root@'192.168.0.1%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; http://dev.mysql.com/doc/refman/5.0/en/access-denied.html Link to comment https://forums.phpfreaks.com/topic/71550-need-to-no-about-a-setup-of-my-mysql-and-php/#findComment-360253 Share on other sites More sharing options...
redarrow Posted October 2, 2007 Author Share Posted October 2, 2007 your need this as well ok. mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql --user=root mysql Link to comment https://forums.phpfreaks.com/topic/71550-need-to-no-about-a-setup-of-my-mysql-and-php/#findComment-360268 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.