Register
|
Forum Index
|
FAQ
|
Search
|
Usergroups
|
Log in
Visit HostMySite.com
Forum Index
»
VPS (Virtual Private Servers)
» Post a reply
Post a reply
Username
Subject
Message body
Emoticons
View more Emoticons
Font colour:
Default
Dark Red
Red
Orange
Brown
Yellow
Green
Olive
Cyan
Blue
Dark Blue
Indigo
Violet
White
Black
Font size:
Tiny
Small
Normal
Large
Huge
Close Tags
Options
HTML is
OFF
BBCode
is
ON
Smilies are
ON
Disable BBCode in this post
Disable Smilies in this post
All times are GMT
Select a forum
HostMySite Forum Topics
----------------
Announcements
General Discussion
Domain Name Information
Email & SmarterMail
VPS (Virtual Private Servers)
Web Design
Programming
Ruby on Rails
ASP & .NET
ColdFusion
PHP
Dedicated Servers
Hosted Exchange and SharePoint Beta
Database
WordPress Blog
Networking Forum
SmarterStats
MIVA Merchant & Ecommerce
Operating Systems
MarketPlace
World's Fastest Server
Topic review
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline"> <tr> <th width="22%" height="25">Author</th> <th>Message</th> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>nathacof</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Wed Sep 12, 2007 3:14 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody"><a href="http://dev.mysql.com/doc/refman/5.0/en/information-schema.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/information-schema.html</a> <br /> <br />[FTA] <br />"Each MySQL user has the right to access these tables, but can see only the rows in the tables that correspond to objects for which the user has the proper access privileges. In some cases (for example, the ROUTINE_DEFINITION column in the INFORMATION_SCHEMA.ROUTINES table), users who have insufficient privileges will see NULL."</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>Jason101</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Wed Sep 05, 2007 3:56 pm<span class="gen"> </span> Post subject: </span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">You can try using PHPMyAdmin <br /> <br />That's how I create users when needed. Seems to give you a little more flexability than the administrator. (Althought the administrator comes in handy for other items) <br /> <br />PHPMyAdmin can sometimes be tricky to setup. But for security, I would limit access to it from your server only.</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> <tr> <td width="22%" align="center" valign="top" class="row"><span class="name"><a name=""></a><b>malik</b></span></td> <td class="row" height="28" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><img src="templates/Morpheus/images/gray/icon_minipost.gif" width="12" height="9" alt="Post" title="Post" border="0" /><span class="genmed">Posted: Wed Sep 05, 2007 3:52 pm<span class="gen"> </span> Post subject: Mysql (jason?)</span></td> </tr> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td colspan="2"><span class="postbody">I am using sql adminstrator to create users. <br />When creating users in this way i note all the users have access to the information_schema database. <br />Is there a reason for this or a better way to create new users? <br /> <br />=========================== <br /> <br />"INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains" <br /> <br />============================ <br /> <br />TIA</span></td> </tr> </table></td> </tr> <tr> <td colspan="2" class="spacerow"><img src="./templates/Morpheus/images/spacer.gif" alt="" width="1" height="1" /></td> </tr> </table>
Powered by
phpBB
© phpBB Group
Design by
phpBBStyles.com
|
Styles Database
.
Content ©
DupeDB
