wolfpack_brandon Posted April 5, 2008 Share Posted April 5, 2008 i just installed wamp , n put the server online. i checked phpmyadmin and it works. i am trying to install a software on my website and it asks for hostname, MYSQL username, and MYSQL password. where do i go to get this information because wamp didnt ask me to input anything. plz help me Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/ Share on other sites More sharing options...
Daniel0 Posted April 5, 2008 Share Posted April 5, 2008 The hostname would be localhost. If it didn't tell you to choose any passwords, then the root user's password is probably blank. You can use phpmyadmin to change the root user's password and create new users. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510221 Share on other sites More sharing options...
wolfpack_brandon Posted April 5, 2008 Author Share Posted April 5, 2008 i created a new account by going to privileges and gave that account all the powers. but when i go to my site to install a software and it asks me for the info. when i put it in it gives me the error of wrong username or password. the webserver is hosted somewhere else and this database is going be hosted off my home machine. so for hostname i put localhost for username i put in brandon password i put in mypassword. is there anything i am doing wrong???? Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510226 Share on other sites More sharing options...
Daniel0 Posted April 5, 2008 Share Posted April 5, 2008 the webserver is hosted somewhere else and this database is going be hosted off my home machine. In that case the hostname will have to be your IP address. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510229 Share on other sites More sharing options...
wolfpack_brandon Posted April 5, 2008 Author Share Posted April 5, 2008 when it asks for a hostname when i go to privileges should i also put my ip address in there? Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510231 Share on other sites More sharing options...
Daniel0 Posted April 5, 2008 Share Posted April 5, 2008 That hostname refers to where connections can come from. That would be the IP of your server where your website is installed. You could also just set it to any. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510235 Share on other sites More sharing options...
budimir Posted April 6, 2008 Share Posted April 6, 2008 If I understand you correctly, your site will be hosted on some server on ISP provider. In that case, I would say the username is NOT root, neither the password is blank. You will probably need to contact admin of these servers and ask for the username and password. Or, maybe you have recived these info when you have made an agreement with them. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510376 Share on other sites More sharing options...
Daniel0 Posted April 6, 2008 Share Posted April 6, 2008 He said he just installed it. In that case the password is blank and it's quite likely that the only existent user is the root user. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510381 Share on other sites More sharing options...
wolfpack_brandon Posted April 6, 2008 Author Share Posted April 6, 2008 He said he just installed it. In that case the password is blank and it's quite likely that the only existent user is the root user. you are right, however he is rite too when he says " If I understand you correctly, your site will be hosted on some server on ISP provider." and the mysql database will be hosted on my computer. so are u certain i should put the ip address of the website provided by my isp, because i thought it would be my ip address. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510513 Share on other sites More sharing options...
wildteen88 Posted April 6, 2008 Share Posted April 6, 2008 It would be helpful if you clearly state what you are trying to do. You say you have installed WAMP, I presume on your computer. What is the reason from having a remote website and using a MySQL on your local computer as the database? Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510617 Share on other sites More sharing options...
wolfpack_brandon Posted April 6, 2008 Author Share Posted April 6, 2008 my web hoster charges me extra, a lot, of having a mysql database. plus even if i do get a database from them, i dot have sufficient privileges to create extra tables. so i decided to create a mysql database on my home machine. JOOMLA requires a mysql database, i was hoping i could use the one on my home computer(the mysql database). Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510704 Share on other sites More sharing options...
wildteen88 Posted April 6, 2008 Share Posted April 6, 2008 If you host your database on your home computer it'll mean you computer will need to be on 24/7 and your site may become slow when doing SQL queries. I'd recommend looking for a new host which provides atleast as database as part of the basic hosting plan. If you still want to to host your MySQL database from your computer then you'll need to have a static ip address, ensure you enable port forwarding for port 3306 on your router (if you have one). Allow for remote connections on port 3306 in your firewall. Add your hosts IP address to MySQLs permissions table. Quote Link to comment https://forums.phpfreaks.com/topic/99760-wamp-and-mysql/#findComment-510755 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.