473,503 Members | 1,706 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Users and hosts-Newbe ?

Hello,
Can someone answer a few questions:

Some background:

Host table has 0 entries
User table has:
+-----------+------+
| Host | User |
+-----------+------+
| localhost | |
| % | |
| localhost | mike |
+-----------+------+

I thought I deleted the root, but the Processes shows :
+----+------+----------------+--------+---------+------+--------+-----------
------------+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+----------------+--------+---------+------+--------+-----------
------------+
| 15 | root | 127.0.0.1:1254 | mysql | Sleep | 243 | | [NULL]
|
| 27 | root | 127.0.0.1:1296 | [NULL] | Query | 0 | [NULL] | SHOW FULL
PROCESSLIST |
+----+------+----------------+--------+---------+------+--------+-----------
------------+

1. If there are no hosts than how can the user table have hosts?
2 If there is no root than why is the always one connected even after a
restart?
3. Whats a blank username?
4. Who is @%?

Many Thanks
Mike
Jul 19 '05 #1
0 1010

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3516
by: Bla | last post by:
Hello, Does anyone have a script that would remove the appropriate line from the hosts file on a UNIX box. This might be a tricky one? Let's say we have a list of hosts and associated ip's we...
0
2014
by: bruce | last post by:
Hi... Update.... We have the following setup in our httpd.conf file. We've tried to give what's related to the issue. We're trying to set up a virtual host for a test project. The behavior...
0
2980
by: David Swanson | last post by:
I am trying to configure the proxy section of the machine.config to handle BOTH connecting to hosts that are not "live" but rather defined in my winnt/system32/drivers/etc/hosts file. AND to hosts...
2
1970
by: Brian Henry | last post by:
I am working on a internal intranet site, and i need to make a permissions page, all the account authorization is done through AD to let them see the intranet site.. now, the permissions page i...
14
4792
by: Lauri Kotilainen | last post by:
Hi, I've already tried several avenues for this, and am quite stumped. The issue I'm facing is a weird case of sessions getting mixed up (ie. users seeing each others' data). Apparently this...
7
3002
by: Bob | last post by:
I'm using PHP 5.1.1 with Apache 2.0.54 and several virtual hosts. PHP is installed as a module. I've created a very simple test page containing <?php phpinfo(); ?> and placed it at the doc root...
3
1081
by: Ben Holness | last post by:
Hi all, I have been asked to build a server that allows people to upload/download files to that server via FTP, but they want an web interface to manage the files and users. I know how to do...
7
1394
by: =?Utf-8?B?SnVzdGlu?= | last post by:
Hello Everyone: I am having the most bizarre problem with my asp.net web app...this is my first web app in asp.net and I inherited it from a programmer who quit...so, I am not completely...
4
1481
by: DanWeaver | last post by:
I am dumbfounded at the apparent lack of an obvious mechanism that prevents finding a shared host being the absolute nightmare it is: due to the nature of the business (ie techies who know about...
5
2867
by: mike.coakley | last post by:
Does stream_socket_client use the /etc/hosts file? I'm using Mac OSX 10.5.3 as a development platform and VMware Fusion for VM hosting. I have a OpenSUSE Linux VM that has an Apache 2 web server...
0
7083
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...
0
7278
Oralloy
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,...
0
7328
jinu1996
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...
0
7456
tracyyun
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...
0
5578
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4672
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1510
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 ...
1
734
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
379
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.