While messing around with some of my other sites I ran into a major problem. I had developed a great deal of conent for the main site and thought it would be great to make a seperate site for mobile users. The new site would of course be much smaller and compact but still allow the majority of data from the main site to be viewed.
When I started developing the mobile site hit a brick wall, I could not connect to the database on my main site even though both sites were on the same server. I tried connecting to localhost as well as the IP address, specifying the db name or calling it from the query. Needless to say it tooks hours to figure out what was going on so here is my solution.
Note: These sites are hosted on a MediaTemple DV server which is a virtualized dedicated server run through PLESK. Each domain hosted on the server gets assigned it’s own db.
Log into the SSH terminal and go to your mySQL prompt by using the following command line:
mysql –uadmin –p`cat /etc/psa/.psa.shadow`Your promt should now look like:
mysql>
Once you are in your mySQL prompt you can create a new user(which is what I did) or you can just modify an existing user.
To create a new user, replace your ip below, *** is the password:
CREATE USER 'username'@'255.255.255.255' IDENTIFIED BY '***';Next we need to give prvileges to this user:
GRANT SELECT ,INSERT ,UPDATE ,DELETE ,CREATE ,DROP ,FILE , INDEX ,ALTER, EXECUTE ON * . * TO 'username'@'255.255.255.255' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;And finally we need to grant privileges to all the databases on the server:
GRANT ALL PRIVILEGES ON * . * TO 'username'@'255.255.255.255';So now that the user is set up with all the correct privileges we can flush privileges and call this job done:
FLUSH PRIVILEGES;
Notes: Now I know this may not work for everyone and it is a rather generic setup but the above is meant to give you a starting point for opening up permissions accross a server. You will need to modify the above if you want only specific permissions given as well as access to only certain databases.
![[del.icio.us]](http://scriptperfect.com/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://scriptperfect.com/wp-content/plugins/bookmarkify/digg.png)
![[dzone]](http://scriptperfect.com/wp-content/plugins/bookmarkify/dzone.png)
![[Facebook]](http://scriptperfect.com/wp-content/plugins/bookmarkify/facebook.png)
![[Furl]](http://scriptperfect.com/wp-content/plugins/bookmarkify/furl.png)
![[Google]](http://scriptperfect.com/wp-content/plugins/bookmarkify/google.png)
![[LinkedIn]](http://scriptperfect.com/wp-content/plugins/bookmarkify/linkedin.png)
![[MySpace]](http://scriptperfect.com/wp-content/plugins/bookmarkify/myspace.png)
![[Newsvine]](http://scriptperfect.com/wp-content/plugins/bookmarkify/newsvine.png)
![[Propeller]](http://scriptperfect.com/wp-content/plugins/bookmarkify/propeller.png)
![[Reddit]](http://scriptperfect.com/wp-content/plugins/bookmarkify/reddit.png)
![[Slashdot]](http://scriptperfect.com/wp-content/plugins/bookmarkify/slashdot.png)
![[Spurl]](http://scriptperfect.com/wp-content/plugins/bookmarkify/spurl.png)
![[StumbleUpon]](http://scriptperfect.com/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://scriptperfect.com/wp-content/plugins/bookmarkify/technorati.png)
![[Twitter]](http://scriptperfect.com/wp-content/plugins/bookmarkify/twitter.png)
![[Email]](http://scriptperfect.com/wp-content/plugins/bookmarkify/email.png)
Sites You Should Check Out…
http://www.lifereader.com/psychics/clairvoyant_phone_readings...
Recent Blogrolls……
[...] Blogpost: edit .. found this post pertaining to [...]…
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Visitor recommendations…
[...]one of our visitors recently recommended the following website[...]……
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Visitor recommendations…
[...]one of our visitors recently recommended the following website[...]……
Links…
[...]Sites of interest we have a link to[...]……
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
Sites we Like……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
Hello…
My wife and i got very thankful Michael managed to deal with his investigations through the entire precious recommendations he acquired in your web pages. It’s not at all simplistic to simply happen to be freely giving ideas which many people have bee…
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Links…
[...]Sites of interest we have a link to[...]……
Superb website…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
Links…
[...]Sites of interest we have a link to[...]……
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
Related……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Websites you should visit…
[...]below you’ll find the link to some sites that we think you should visit[...]……
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Related……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
Links…
[...]Sites of interest we have a link to[...]……
christian dating sites…
Howdy! Someone in my Myspace group shared this website with us so I came to look it over. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers! Exceptional blog and amazing design and style….
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
Bed Bath and Beyond Coupons…
http://bedbathandbeyondcoupons.me/bedbathandbeyondcoupons/...
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
Blogs to visit…
[...] Lots of men and women have total-time attribute and are destined to be undertaking an occupation swap [...]…
dating singles…
Thank you for the sensible critique. Me and my neighbor were just preparing to do a little research on this. We got a grab a book from our local library but I think I learned more clear from this post. I am very glad to see such great info being shared…
Check this out…
Thanks for this post. I think it may be useful for my business, please write sth else about it….
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
Related……
[...]just beneath, are numerous totally not related sites to ours, however, they are surely worth going over[...]……
… [Trackback]…
Wonderful work! This is the type of information that should be shared around the internet. Shame on Google for not positioning this post higher! Come on over and visit my website . Thanks =)…
Great website…
Here are some of the sites we recommend for our visitors…
Cool blog…
[...]while the sites we link to below are completely unrelated to ours, we think they are worth a read, so have a look[...]…
seks…
Cipeczki chetne do wyruchania za darmo….