good day all!
i'm getting really confused with how to properly allow
users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
after this, i can access mysql as
I am using MySql to store telephone taxes statistics.
I have 1 table by month with 60'000 rows each.
My problem is that I need some stats for 3 month.
For example I need to know the total Time(in second) and total Cost
for each Number on a 3 month basis.
Is it possible to do it without creating
On Fri, Jul 30, 2004 at 11:46:02AM -0500, Pete Harlan wrote:
On Thu, Jul 29, 2004 at 06:26:23PM +0300, Egor Egorov wrote:
...
No. I've forgot to tell that the -Max binary is linked dynamically
because it uses SSL.
Is there a reason the SSL libraries can't also be linked statically?
I
Thanks very much Michael, you were right.
I spent hours worrying about this yesterday. The documentation implied
that you don't have to log on at all.
Cheers
Dave
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: 02 August 2004 05:11
To: Prout,DA,Dave,XSJ67
On Fri, Jul 23, 2004 at 01:44:16PM -0400, Michael Sleman wrote:
Does MyISAM lock the whole table when doing SELECTs?
Yes, each client obtains a read lock on the table for a SELECT query.
How about if there are several processors? Is there locking?
It's no different with multiple CPUs.
Jeremy
On Sun, Aug 01, 2004 at 08:42:50PM +0300, Issac Goldstand wrote:
I just set up another reeplication slave for one of my servers - it's not
something new to me. I'm using 4.1.3-beta on a new server which will
eventually take over as the master. I set up a server id, did change
master to...
On Mon, Jul 26, 2004 at 01:26:15PM -0500, gerald_clark wrote:
Steve Richter wrote:
exactly! Is Linux distributed under the same type of license as MySql? If
I sell software that runs on linux I dont have to give away my code, right?
To use my software you first have to install no charge
On Mon, Jul 26, 2004 at 05:43:58PM -0400, Steve Richter wrote:
looks like the answer is no. As soon as fee based software touches the
mysql install on the PC, the user is obligated to pay the $250. At least I
guess it is the user who has to pay.
So a copy of MySQL on Windows is free until
On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
At 04:43 PM 7/26/2004, you wrote:
looks like the answer is no. As soon as fee based software touches the
mysql install on the PC, the user is obligated to pay the $250.
Actually I believe the MySQL 4.x license is more stringent than
Don't I feel stupid. It was the password. I'd actually pasted the password
into both the master and slave (and did it again just in case yesterday), so
I feel quite foolish about that. However, I could swear that at one point
if there was an authentication failure, I'd get some report of a
Jeremy Zawodny [EMAIL PROTECTED] wrote on 02/08/2004 09:41:40:
On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
At 04:43 PM 7/26/2004, you wrote:
looks like the answer is no. As soon as fee based software touches
the
mysql install on the PC, the user is obligated to pay the $250.
Somewhere about Sun, 01-Aug-2004 at 11:31AM -0400 (give or take), Michael Stassen
wrote:
|
| Patrick Connolly wrote:
[...]
| Looks to me the mysql user should have no trouble with it:
|
| -rw-rw-r--1 pat pat 332 Jun 28 20:42 Orders.txt
|
| Every piece of the path to
hi friends
i am trying to create a data model for my new database.
i have some problems in normalising my data model.
i have two tables with many-to-many relation.
how to i normalize them to one-to-many form.
--
molecule_info
--
mol_id
mol_name
Hi,
suppose I've got a table RichMan with columns
ID, Name, Bucks
1, 'John', 300
2, 'Joe', 700
3, 'Al', 400
4, 'Fred', 250
5, 'Jim', 480
and I sort them with respect to Bucks. Then John would be on the first
place because he ist the richest, followed by 'Jim', etc.
Now I'm looking for an
Shannon R. [EMAIL PROTECTED] wrote:
i'm getting really confused with how to properly allow
users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
after
--
molecule_info
--
mol_id
mol_name
---
---
plant_info
---
plant_id
plant_name
here, i one mol_name is found in more than one plant_name.
the same way, one
Issac Goldstand [EMAIL PROTECTED] wrote:
I just set up another reeplication slave for one of my servers - it's not
something new to me. I'm using 4.1.3-beta on a new server which will
eventually take over as the master. I set up a server id, did change
master to... and started the slave -
Denis Geser [EMAIL PROTECTED] wrote:
I am using MySql to store telephone taxes statistics.
I have 1 table by month with 60'000 rows each.
My problem is that I need some stats for 3 month.
For example I need to know the total Time(in second) and total Cost
for each Number on a 3 month basis.
- Original Message -
From: vijaya raj [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 02, 2004 7:11 AM
Subject: help-in-normalizing
hi friends
i am trying to create a data model for my new database.
i have some problems in normalising my data model.
i have two tables
adp [EMAIL PROTECTED] wrote:
I have several MySQL and FreeBSD installs across a few different sites, and
I consistently have problems with mysqld. It will begin to eat up all of the
CPU and eventually become unresponsive (or the machine will just burn). I
can't seem to manually reproduce
On Monday 02 August 2004 02:39, Denis Geser wrote:
I am using MySql to store telephone taxes statistics.
I have 1 table by month with 60'000 rows each.
My problem is that I need some stats for 3 month.
For example I need to know the total Time(in second) and total Cost
for each Number on a 3
rmck [EMAIL PROTECTED] wrote:
I thought I could wrap this LOAD DATA option in my perl script which could
speed things up... Any help is great
You can consider using bulk insert.
See http://dev.mysql.com/doc/mysql/en/INSERT.html and note that you can
insert more than a single row at
Michael Gale [EMAIL PROTECTED] wrote:
I have a question about data loading using mysql 4.0.20. If you need to load
let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local infile which is
a
Nathan Boeger [EMAIL PROTECTED] wrote:
Its accessed over the net by the web servers. I don't think we would
have file contentions.
Actually, we just replaced the mysql binary with an older 4.0.16 version
that we compiled and used before we started to use the 4.0,20-i686-icc.
Now the db
Yves Goergen [EMAIL PROTECTED] wrote:
I'm using UTF-8 in my newsboard, too, and I have no major problems with
it. UTF-8 doesn't need to be handled as binary, I believe, since all
characters should be in a range over the control characters. Anyone
please correct me, if that's wrong...
Tris
Pete Harlan [EMAIL PROTECTED] wrote:
No. I've forgot to tell that the -Max binary is linked dynamically
because it uses SSL.
Is there a reason the SSL libraries can't also be linked statically?
There was some reasons. Afair, MySQL is not the only software which could not
be statically
Wolfgang Riedel [EMAIL PROTECTED] wrote:
could someone please tell me which versions of mysql support SSL
connections for both clients and replication slaves?
The -Max build.
i'd installed MySQL-Max-4.0.20-0.i386.rpm from download area of
www.mysql.org, but the server doesn't start with
Why do I include some WHERE restrictions in my ON clauses and encourage
others to do it, too? Because I believe that the WHERE clause is applied
AFTER the temporary virtual table (the result of applying all of the JOIN
and ON clauses in the full statement) is complete. That is also why I am
Actually, no, it isn't in memory (except for that breif period of time
before the write cache is committed to disk). You are actually creating a
new, disk-based database and populating it with data.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Jacob, Raymond A Jr
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I have
inherited a database from someone else in which there is a table with
project information and a field containing which geographic regions the
projects relate. As a single project can relate to multiple
Have you run an explain before each scenario to see if the access path is
different?
-Original Message-
From: Jeremy Zawodny
To: Marc
Cc: [EMAIL PROTECTED]
Sent: 8/1/04 8:28 PM
Subject: Re: better performance with optimize!?? (jboss)
On Sun, Aug 01, 2004 at 01:42:24PM +0200, Marc wrote:
Did you compile mysql from source or you use precompiled binary package?
I use mysql with different versions of FreeBSD without big problems.
adp [EMAIL PROTECTED] wrote:
I have several MySQL and FreeBSD installs across a few different sites, and
I consistently have problems with mysqld. It will
Well, giving the rank and getting the ID is simple:
SELECT * FROM RichMan ORDER BY Bucks DESC LIMIT 4,1
That will return 1 record starting at the 4th record.
The first one is a bit tougher. Thinking on it.
On Aug 2, 2004, at 7:23 AM, Horst Jäger wrote:
Hi,
suppose I've got a table RichMan with
On Monday 02 August 2004 02:39, Denis Geser wrote:
I am using MySql to store telephone taxes statistics.
I have 1 table by month with 60'000 rows each.
My problem is that I need some stats for 3 month.
For example I need to know the total Time(in second) and total Cost
for each Number
Hello:
I posted this before but I have not gotten a response. I have a Debian
(woody) server running a good sized database (7.2GB of db files), Mysql
4.0.18. I am running Apache 1.3.29 + perl and using mysql as the
backend. In my.cnf, I have max_connections=300.
Here's the problem. I had
What I have here is a database-driven website. In the past, I created a
database and grant privileges to it. Now, I'm creating a carbon copy of
it into another website which will be a test website with a test
database. So, when I try the grant privileges to the test database, it
returned a zero
Andrey Kotrekhov [EMAIL PROTECTED] wrote:
Did you compile mysql from source or you use precompiled binary package?
I use mysql with different versions of FreeBSD without big problems.
On FreeBSD, you can compile MySQL from ports.
I have several MySQL and FreeBSD installs across a few
What does mysql show processlist look like?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not gotten a response. I have a
Debian
(woody) server running a good
- Original Message -
From: vijaya raj
To: Rhino
Sent: Monday, August 02, 2004 9:31 AM
Subject: Re: help-in-normalizing
dear rhino and whil
thanks for that valuable tip.
but, dont i have to wory about the repeating id's (are they not redundant...) in
this table,
.
Usually I run configure like this:
./configure \
--prefix=/usr/local/mysql_4 \
--without-debug \
--with-charset=koi8_ru \
--with-extra-charset=koi8_ukr,win1251,win1251ukr \
--with-mysqld-user=X \
--without-berkeley-db \
--without-isam \
--without-innodb \
--enable-thread-safe-client
Hi,
I just upgraded to mysql-4.0.20 compiled using gcc-3.3.3. All my C++ DB
interfaces connecting to this mysql database seem to run into a problem -
when I try to disconnect, mysql_close() is called but the program just hangs
there without being able to close the connection. Can someone please
How stable is this feature? , i have been using it for a few time and works
fine, but im thinking to move my current productive enviroment this way and
i dont know if its a good choice.
Any advise is appreciated.
Carlos
_
Tired of
Is it possible to verify the database backup. Like most machines, that
make backup of files then verify that all of it is backed up without an
error? I use mysqldump to make a backup but I have no idea about the
verify
Thanks,
Scott
On Mon, 2 Aug 2004 01:35:44 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Mon, Jul 26, 2004 at 01:26:15PM -0500, gerald_clark wrote:
Steve Richter wrote:
exactly! Is Linux distributed under the same type of license as MySql? If
I sell software that runs on linux I dont have to
Victor Pendleton said:
What does mysql show processlist look like?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/2/04 9:16 AM
Subject: Problem with Mysql 4.0.18 + Debian
Hello:
I posted this before but I have not gotten a response. I have a
Debian
i'm getting really confused with how to properly
allow users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.*
TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
after this, i can access mysql as 'dbuser' from
Shawn,
I see what you are saying, but I don't believe it works that way. If that
were the case, putting the condition in the ON clause rather than the WHERE
clause would be at the top of the list of recommended optimizations in the
manual, but it's not. In fact, the manual recommends against
dear rhino and whil
thanks for that valuable tip.
but, dont i have to wory about the repeating id's (are they not
redundant...) in this table, excuse me if this query looks silly...
PLANT_MOLECULE
plant_idmolecule_idquantity
---
1
Anyone know of some decent docs on how CR works with MySQL using ODBC 3.51.
Just installed it today to see what it's like and am finding it cumbersome.
This is most likely due to ignorance rather than the product.
I was expecting to see a list of tables available for reporting when using a
link
Hello,
I have a problem.
Lithuanian letters:
aceeisuuz
What I must use to sort by this ORDER?
When I use
mysql CREATE TABLE w
(
s VARCHAR(5) CHARACTER SET cp1257 COLLATE cp1257_lithuanian_ci
);
Query OK, 0 rows affected (0.04 sec)
mysql insert into w
Hi,
Hoping that someone can help me, as I have tried everywhere for help and
still cannot get this to work.
I am using MySQL 4.1.1
I have a sql file that contains french accent characters. I have 8 fields in
my database. Now the content of the text file imports into my database, when
I import
Hi,
Hoping that someone can help me, as I have tried everywhere for help and
still cannot get this to work.
I am using MySQL 4.1.1
I have a sql file that contains french accent characters. I have 8 fields in
my database. Now the content of the text file imports into my database, when
I import
On Mon, Aug 02, 2004 at 09:24:59AM -0700, Marc Slemko wrote:
I believe that MySQL AB is deliberately vague and confusing on their
licensing page to try to get people to buy mysql licenses. All
their words there don't matter though, what matters is the actual
license. It would, however, be
On Tue, Jul 20, 2004 at 04:18:42PM +0800, [EMAIL PROTECTED] wrote:
I am new to MaxDB and clustering. It seems that both products provide
enterprise features and high availability.
Is clustering replacing MaxDB?
What are the difference between them?
Are they targeting different users?
Based
Do you know the ASCII values for the characters that are being turned into
question marks? Are you able to verify that the data is not be imported by
querying the underlying ascii value?
-Original Message-
From: Barry Zimmerman
To: [EMAIL PROTECTED]
Sent: 8/2/04 1:00 PM
Subject: Mysql
You are absolutely right, I was giving the developers too little credit. I
humbly apologize to all who contributed to the query optimizer. It was
never my intent to impugn the fine work that has gone into MySQL, my
optimization strategy is merely a reflection of my own pessimism. Please
i've got one master and one slave. the master is VERY busy, tons of
inserts/updates/deletes all the time. (it's an extremely high traffic
message board system.)
we've got a situation right now where the slave starts lagging WAY
behind the master. it's as if it simply can't run through the
Hi,
It sounds like you are using the default thread library. I would
install MySQL from /usr/ports/databases (WITH_LINUX_THREADS, see
options in Makefile) or barring that try Jeremey's excellent build
recipe at http://jeremy.zawodny.com/blog/archives/000458.html . We
used to have the same
Hi
Just installed myqsl for windows w/ installer and looked in the
directory and found no example .cnf files
james
At 03:41 AM 8/2/2004, Jeremy Zawodny wrote:
On Mon, Jul 26, 2004 at 11:49:02PM -0500, mos wrote:
At 04:43 PM 7/26/2004, you wrote:
looks like the answer is no. As soon as fee based software touches the
mysql install on the PC, the user is obligated to pay the $250.
Actually I believe the
Oops, I lied. :) -Max was built with SSL a long time ago (if I
remember right), and now it's not. Sorry.
...I noticed this earlier, too.
Note that your website still claims this (The Max version includes
additional features such as the Berkeley DB storage engine and other
features that have
Hello everyone,
I met a strange problem.
I can't log in mysql server using my password
suddently.
I check the modified date of user.MYD user.MYI in
/usr/local/mysql/data/mysql/ folder. Both of them were
not modified recently. That means I didn't change the
password for mysql server.
Did anyone
Did your client side host change? The user/pass are sometimes setup to
only allow access from a specific host subnet or single ip address.
John A. McCaskey
-Original Message-
From: Jean Zhong [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 1:27 PM
To: [EMAIL PROTECTED]
- Original Message -
From: Andrew Dixon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 02, 2004 9:44 AM
Subject: In Statement Help
Hi Everyone.
I require some help with an IN statement I'm trying to get working. I have
inherited a database from someone else in which
Greetings:
I am trying to upgrade to the new version of mySQL on Fedora Core 2 Linux. I have
mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
I downloaded the following files:
MySQL-client-4.0.20-0.i386.rpm
MySQL-server-4.0.20-0.i386.rpm
and as root ran the following:
[EMAIL
Hi, John
Thank you for the response.
I chmod for all database files under ./data/, and now
I can update the password for the root user.
Thanks a lot.
Jean
--- John McCaskey [EMAIL PROTECTED] wrote:
Did your client side host change? The user/pass are
sometimes setup to
only allow access
On Mon, Aug 02, 2004 at 03:11:10PM -0500, mos wrote:
At 03:41 AM 8/2/2004, Jeremy Zawodny wrote:
I bet it depends on the country. In the USA, companies are considered
singular legal entities. Internal distribution is aking to giving
copies to yourself.
The GPL doesn't restrict that.
At 01:58 PM 8/2/2004, [EMAIL PROTECTED] wrote:
Greetings:
I am trying to upgrade to the new version of mySQL on Fedora Core 2
Linux. I have mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
I downloaded the following files:
MySQL-client-4.0.20-0.i386.rpm
My connection to the mysql is correct, that is host, username, password,
however when I click the link of form so that it will pull out data from
mysql database, I see the php code of the form, any guidance, please.
I wound up having to do the following:
[EMAIL PROTECTED] Desktop]# rpm -Uvh MySQL-shared-compat-4.0.20-0.i386.rpm
warning: MySQL-shared-compat-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
Preparing...### [100%]
At a loss on this one...
- Original Message -
From: [EMAIL PROTECTED]
Date: Monday, August 2, 2004 5:27 pm
Subject: Re: Question
Yes, extension of file is php and php is running on server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I am now getting
[EMAIL PROTECTED] Desktop]# mysql -u root -pmypasshere
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
any thoughts...
once again thanks for the assistance
- Original Message -
From: [EMAIL PROTECTED]
Date: Monday,
---BeginMessage---
Long back I had set it and was working that time,For a long time I wasn't working on same, at this point how to check the same, I don't remember, can you guide , please.
How do I check if mysql, php apache are configured, also any GUI graphical user interface for Apache
When I then ran mysqlshow I only had the test database, not the mysql
database as the documentation said I should.
I then deleted everything and installed again, and got the same result.
Does this mean the installation has failed ?
When this happens on Linux, it means you're running
We're upgrading from 3.23.58 to 4.0.20 and found that that although the
ALTER test results of sql-bench had been greatly improved, CREATE has
shown nasty performance degradation. Just before needing to make the
decision to revert back to 3.23.58, we found a post here where someone
had a similar
in my Linux Services... the mysqld entry is missing
i have mysql and that is supposedly running.
- Original Message -
From: Carlos Proal [EMAIL PROTECTED]
Date: Monday, August 2, 2004 6:19 pm
Subject: Re: Upgrading mySQL 3.23 to 4.0
The upgrade shutdown the database, i think you must
Yes, extension of file is php and php is running on server.
RRD (http://www.rrdtool.org) is a popular tool which sysadmins use to
collect to network stats (among other things)
One of the best thing about RRD is that it only stores X datapoints at
any one time, and also aggregates simple stats about the data, making it
self-archiving. I was wondering if
tSql = SELECT c.campaign_name, c.id
FROM campaigns as c
INNER JOIN addresses_incampaign as i on (c.user_id = i.user_id)
WHERE c.user_id = prepSQL(tConn, user_id)
GROUP BY c.id;
This works when there is data in the addresses_incampaign table, but when
there is not, it returns nothing, which is
Hi ppl,
Im trying to access to mysql server by telnet. When I do like telnet
localhost 3306 if I write something the error is Bad handshake. Well can
anyone tell me what info do I need to send to the server to establish a
connection with mysql server? So I can execute some queries?
Here is what I am doing now, in mysql 4.x
This gives me a name/id list from a table
SELECT campaign_name, id
FROM campaigns
WHERE user_id = 123;
This will tell me which of the above name/id's are in use in another table.
SELECT distinct(campaign_id)
FROM addresses_incampaign
WHERE user_id = 123
-Original Message-
From: Jacob, Raymond A Jr
Sent: Monday, August 02, 2004 21:17
To: [EMAIL PROTECTED]
Subject: archive db daily- Rough Draft
I am new to Databases and would appreciate a second set of eyes looking over my sql
script.
The script takes the existing snort database and
Is the 2GB filesize limit in linux still there?
Specially in Gentoo and Debian linux?
If so, how can this be addressed when your mysql's
.MYD files reach 2GB?
Is there any way MySQL can split really big .MYD
files?
Regards,
Shannon
__
Do you
Hi folks,
Now that I can connect to my MySQL server using the Unix sockets (e.g.
[EMAIL PROTECTED] ~] mysql -u root
I'm moving on to the next step - connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I SSH into the box
supposedly ?, you can check if the mysqld daemon is running with:
ps -ef | grep mysql
if the daemon is running then the error is something else but my first bet
is that is not running.
Carlos
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Carlos Proal [EMAIL PROTECTED]
CC: [EMAIL
Hi, you cant connect to mysql with telnet, the service running in 3306
supports a dbms specific protocol so you need to use the mysql command aka
mysql client to connect to mysql and execute any sql query.
Carlos
From: Gonçalo Silva Dias [EMAIL PROTECTED]
To: [EMAIL PROTECTED],[EMAIL
Depends on what file system you are running that is a ext2 limit if you move
to ext3 or reiser you should be fine. But then a default config on MySQL will run into
a 4.29 Gig limit, which you can change.
Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED]
Shannon R.
What does your '/etc/hosts' file contain? Sounds like
it may have the following entry:
127.0.0.1 localhost.localdomain
change it to:
127.0.01localhost
or
Yes, add 'localhost.localdomain' to mysql.user
another option, Why not just SSH to 'daisy' and issue:
shell mysql -u root -p
If you want the data in the campaigns table regardless if an entery exists
int he addresses_incampaign table then you should use a LEFT OUTER JOIN.
-Original Message-
From: Scott Haneda
To: MySql
Sent: 8/2/04 7:37 PM
Subject: Cant get this JOIN to work
tSql = SELECT c.campaign_name, c.id
Ryan,
Here's the problem. I had the site up several days, with everything
running perfectly. Ordinarily there would be about 11 mysql processes
running. However, after a few days of running smoothly, the number of
mysql processes increases to over 170, and the site crashes. Formerly
I'd
On Mon, 02 Aug 2004 17:31:03 -0400
[EMAIL PROTECTED] wrote:
I am now getting
[EMAIL PROTECTED] Desktop]# mysql -u root -pmypasshere
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
any thoughts...
once again thanks for the assistance
It
From mysql's point of view, localhost and 127.0.0.1 are not the same thing.
When you connect with
mysql -h localhost -u root -p
or simply
mysql -u root -p
(localhost is the default), you are connecting via unix socket, so the
user=root, host=localhost entry is used. When you connect with
92 matches
Mail list logo