I'm sure there's a good explanation, but I haven't seen it in any of the
documentation. When I query the mysql database in the user table I see
two roots--one with the host as "localhost" and the other with the host as
"linux.site ." I suppose this is normal, but I don't understand why.
This is sort of a repost from yesterday, but since then I reinstalled
linux from scratch (SUSE 9.2 pro) I haven't yet added any users or set any
passwords--I haven't yet done anything to screw-up this pristine install.
Is it normal to see two roots in this kind of query? Last time I went in
as root and really messed things up. here's my second chance.
mysql>SELECT user, host, password FROM user;
+------+------------+----------+
| user | host | password |
+------+------------+----------+
| root | localhost | |
| root | linux.site | |
| | localhost | |
| | linux.site | |
+------+------------+----------+
4 rows in set (0.00 sec)
mysql>
Which root is the "real" root? Should I delete the anonymous users? Do
I need at least one limited guest account for my soon-to-be-written PHP
pages? Please advise.
Thanks.
Rich Hollenbeck
3  1796 
It's all explained in p. 130 of the LATEST MySQL Reference Manual.
Oscar
On 11/25/04 09:55, in article pa************* *************** @verizon.net,
"Richard Hollenbeck" <ri************ ****@verizon.ne t> wrote: I'm sure there's a good explanation, but I haven't seen it in any of the
documentation. When I query the mysql database in the user table I see
two roots--one with the host as "localhost" and the other with the host as
"linux.site ." I suppose this is normal, but I don't understand why.
This is sort of a repost from yesterday, but since then I reinstalled
linux from scratch (SUSE 9.2 pro) I haven't yet added any users or set any
passwords--I haven't yet done anything to screw-up this pristine install.
Is it normal to see two roots in this kind of query? Last time I went in
as root and really messed things up. here's my second chance.
mysql>SELECT user, host, password FROM user;
+------+------------+----------+
| user | host | password |
+------+------------+----------+
| root | localhost | |
| root | linux.site | |
| | localhost | |
| | linux.site | |
+------+------------+----------+
4 rows in set (0.00 sec)
mysql>
Which root is the "real" root? Should I delete the anonymous users? Do
I need at least one limited guest account for my soon-to-be-written PHP
pages? Please advise.
Thanks.
Rich Hollenbeck
On Thu, 25 Nov 2004 15:31:56 +0000, Oscar A. Moreno wrote: It's all explained in p. 130 of the LATEST MySQL Reference Manual.
Oscar
Thank you Oscar,
I don't actually have that book. Fortunately, I found an online version
at http://dev.mysql.com/doc/mysql/en/De...rivileges.html which may
roughly equate to page 130. Anyway, you're right; it seems to be exactly
the kind of information I was looking for. Now that I know where to go,
for this kind of information in the future, I should be up to speed much
more quickly. I really should buy the paper version of it. Thanks again.
Rich
To get the latest and greatest of the Reference Manual, go to http://dev.mysql.com/get/Downloads/M....pdf/from/pick and select
the mirror closest to your heart and download it to your HD. No need to
spend moollah!!. This is a PDF format.
Oscar
On 11/26/04 00:42, in article pa************* **************@ verizon.net,
"Richard Hollenbeck" <ri************ ****@verizon.ne t> wrote: On Thu, 25 Nov 2004 15:31:56 +0000, Oscar A. Moreno wrote: It's all explained in p. 130 of the LATEST MySQL Reference Manual.
Oscar
Thank you Oscar,
I don't actually have that book. Fortunately, I found an online version
at http://dev.mysql.com/doc/mysql/en/De...rivileges.html which may
roughly equate to page 130. Anyway, you're right; it seems to be exactly
the kind of information I was looking for. Now that I know where to go,
for this kind of information in the future, I should be up to speed much
more quickly. I really should buy the paper version of it. Thanks again.
Rich This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Justin Caldicott |
last post by:
Hi
There are n solutions to the nth root of any number, eg:
(-8)^(1/3) = 1 + sqrt(3)i
or -2
or 1 - sqrt(3)i
The following code:
|
by: temper3243 |
last post by:
Hi,
I have been trying to solve the problem Roots of the polynomial 038
from mipt.ru (el judge). I have failed to do so. I tried to search on
the net but found about contour integrals for routh-hurwitz criterion.
So it is difficult to code.
Can you please tell me how to solve the problem for degree 20 ? and
how to approach the problem for degree 4.
Please do tell me the pseudo code and references.
|
by: Raymond L. Buvel |
last post by:
If you are using the root finder in Numeric, and are having problems,
check out the root finder in the ratfun module. My testing indicates
that it will give the exact roots of a Wilkinson polynomial of degree
100. For more information see
http://calcrpnpy.sourceforge.net/ratfun.html
|
by: Carl Johansen |
last post by:
I have a big ASP website (used by several thousand car dealers) that is a
collection of lots of small and medium-sized applications. Now I want to
start adding ASP.NET applications to it. I have read Q307467 (How To Create
an ASP.NET Application from Multiple Projects for Team Development) and it
seems to work well. I understand that when you create a web project in
VS.NET, it creates an IIS application root, and that you can remove this...
|
by: anand |
last post by:
***********************************************************************************************************
#include<stdio.h>
#include<conio.h>
#include<math.h>
void main()
{
double a,b,c,fa,fb,fc,err;
int count;
| | |
by: aruna |
last post by:
to write a c program to find the roots of the equation using bisection method
that too using array or pointers
|
by: =?ISO-8859-1?Q?Sch=FCle_Daniel?= |
last post by:
Hello NG,
given this call to roots funtion from pylab
In : roots()
Out: array()
as far as I understand it stands for a0+a1*x+a2*x^2
in the above case it yields 2x^2+2x = 2x(1+x)
and the roots are 0 and -1
|
by: candacefaye1 |
last post by:
1. write a C++ program to decide if the coefficients of a quadratic equation have real roots. The three choices will be to write the message “zero divide” when A is zero, write the message “no real roots” if the discriminant is negative and find the two roots when there is no error condition. DO NOT FIND THE ROOT IF THERE IS AN ERROR CONDITION.
2. use a NESTED DECISION to do the three parts of the algorithm above.
3. write a...
|
by: Peng Yu |
last post by:
Hi,
I have the following program which computes roots of a cubic function.
The solution is sensitive to the type, which is due to the truncation
error. 'long double T' gives three solutions, and 'typedef double T'
gives one solutions. The correct number of solutions should be two, 1
and 2.
I know there is some trick to reduce the chance of under or overflow.
For example, std::abs(z) shall be implemented as
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
