I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3
installed. It is a fresh install and I was checking all the system
accounts and noticed that Debian has a 'debian-sys-maint' account on
'localhost'. Has anyone ever removed this account? Do I need it or can
I safely remove this account? I
On Wed, Jan 13, 2010 at 1:14 PM, Jim Lyons wrote:
> I have a script that does this. It goes through every table in every
> database (excluding specific database like information_schema, etc) and
> issues the command:
>
> select 1 from . limit 1;
Interesting. Would you mind sharing the script? Is
I already set the root password for the MySQL root user. That is why
in my 1st email you see the encrypted password listed for root in
localhost, mail, & 127.0.0.1.
Thanks for all your info. I followed Neil's steps and it worked
perfect...after I realised that those were two 's and not a single
qu
I was checking my fresh install of MySQL and noticed I had empt spaces
or missing entries in some sections when I did a search for users on
the 'mysql' database. I checked the MySQL FAQ's and Google and nothing
gave me what I am looking for. I can't understand what this entries
are blank for:
mysq
On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni wrote:
> Remove manually (delete) the user from all the privilege tables:
>
> delete from columns_priv where user='carlos';
> delete from db where user='carlos';
> delete from procs_priv where user='carlos';
> delete from tables_priv where user='carlo
On Wed, Sep 30, 2009 at 1:11 PM, mos wrote:
> Carlos,
> Â Â Get a free copy of SqlYog (Community edition).
> http://code.google.com/p/sqlyog/
Thanks but I don't have any GUI's installed on my machine I manage the
database on or from. I am also trying to learn in case things break
and I only have
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this case. I created a database called 'staff' and
then in that database I created one simple table:
mysql> show tables;
+-+
|
On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty wrote:
> Grant
>
> he is trying to login as that user
> then drop the user he logged in as
No, no and no. I clearly showed my commands including my login to
MySQL as root. I also cleanly noted I can't even login as the user I
am trying to delete.
I
On Tue, Sep 29, 2009 at 11:36 PM, mos wrote:
> Why don't you just say "Drop User carlos"?
> Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Why can't I remove this u
I just created a generic test user account on MySQL 5.1 and now for
some reason I am unable to remove him...
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select User, Hos
On Wed, Jul 29, 2009 at 3:07 PM, Nathan Sullivan wrote:
> Carlos,
>
> I think this does what you want: (untested though)
>
> UPDATE identities
> SET email=replace(email, 'mail.', '')
> WHERE email like '%mail.iamghost.com'
That worked perfect!
UPDATE identities
-> SET email=replace(email, 'mail.'
I know this seems very basic and I checked Google before posting but
it appears that many of the manuals / guides online reference
something a bit more extreme than what I am looking for.
I am searching a table called 'identities' and in that table there is
a column called 'email'. Some people hav
Yup. That was what I was looking for. Thanks!
On Mon, Jul 13, 2009 at 3:27 PM, Ray wrote:
> On July 13, 2009 12:03:49 pm Carlos Williams wrote:
>> If I am looking for a application that will connect to MySQL and allow
>> me to make database / table / user / permission modi
If I am looking for a application that will connect to MySQL and allow
me to make database / table / user / permission modifications via a
graphical tool, is there something specific out there you guys
recommend? I have been doing everything via CLI only and would like to
try a GUI option if availa
On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet wrote:
> Dear All,
>
> I have been using MySQL on FreeBSD for 3 years and encounterd a lot of
> problems related to thread management. And 1 year ago, I found that my
> FreeBSD box does not go well with any MySQL revision after 5.1.17-beta,
> becaus
1 | 0 |1 | Carlos Williams | |
car...@ideorlando.org | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@ideorlando.org | | | NULL | 0 |
2 |
|
1 | 0 |1 | Carlos Williams | |
j...@mdamusic.com | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@mdamusic.com | | | NULL
| 0 | 2 |
|
On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni wrote:
> I don't know if you are now more ore less confused!
>
> Claudio
I would say less because you basically explained that I need to have
localhost & 127.0.0.1.
Now my problem is that no longer have this and would like to know what
I can do to re
Can someone please explain why I have 3 entries for root or if this is
normal behavior for MySQL? I thought after a installation of MySQL,
you normally have 2:
1 - localhost
2 - host.domain.com
For some reason I had a 3rd entry:
3 - 127.0.0.1
I don't know if I did the right thing but I ran the
On Thu, May 14, 2009 at 7:01 PM, Douglas Nelson wrote:
> try running the command like this
>
> select * from user where user='root' \G
>
> Capital G is a must.
I did the following:
[r...@mysql ~]# /etc/init.d/mysqld stop
Stopping MySQL:[ OK ]
[r...@
On Thu, May 14, 2009 at 7:06 PM, Carlos Proal wrote:
>
> The machine mysql.unixslut.com is not the same than localhost, right ??,
> If you only need root access from localhost you can delete the first row
> (delete from user where user='root' and host='mysql.unixslut.com';)
Carlos,
Yes, my mach
On Thu, May 14, 2009 at 6:44 PM, Carlos Proal wrote:
>
> Check how many root rows do you have on the user table (select * from user
> where user='root';), some times there are several rows with different grants
> and probably you are going through and invalid rule.
I checked and when I ran the co
On Thu, May 14, 2009 at 6:31 PM, Carlos Proal wrote:
>
> Hi Carlos
>
> Try this
>
> mysql> update user set password=password('letmein') where user='root';
>
>
> This way the password is saved encrypted, thats the way is compared when you
> try to log in.
Thanks for the reply! I followed both met
I noticed today that I strangely was unable to login to MySQL as root.
I just assumed I forgot the password and decided to reset my root
password:
1 - /etc/init.d/mysqld stop
2 - mysqld_safe --skip-grant-tables &
3 - mysql -u root
4 - mysql> use mysql;
mysql> mysql> update user set password='l
2009/5/13 Pintér Tibor :
> how about reading the fine manual of the GRANT command at mysql.com?
I did to avoid being lazy...go figure. I then decided to ask here
before I make a mistake & I felt the fine manual was not clear enough
for me...
--
MySQL General Mailing List
For list archives: http:
On Wed, May 13, 2009 at 11:15 AM, Michael Dykman wrote:
> One thing though: your user does not need the 'WITH GRANT OPTION' bit
> as that gives them permission to gratn permissions to other users,
> which I don't think is what you want.
How do I change the bit for 'grant all' via the CLI? What co
I have used MySQL twice in my career so I did read the MySQL How-to
page and just wanted to ask here if what I did as correct based on
what I wanted to do. I just wanted to create a new database in MySQL
called "webmail" and then also create a new user who limited to only
accessing the 'webmail' da
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams wrote:
> Now I did create that new database called 'forums' and would like to
> create a new user who has access only to that specific database from
> localhost. I can't seem to find the command via Google on how I cre
On Wed, Apr 22, 2009 at 2:45 PM, George Larson
wrote:
>>> Is this what you mean?
>
> SELECT * FROM user;
Yes. That was exactly what I was looking for. Thank you for that info.
Still learning these commands so pardon my ignorance.
Now I did create that new database called 'forums' and would like
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams wrote:
> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley wrote:
>> All user information is stored in the mysql database. If you want to
>> see a list of users that have been created, query the user information
>> table.
>
This seems to be a simple beginer question for MySQL and I have
searched online but I wanted to ask before I really confuse myself.
I have MySQL running on Linux and right now I have created a 2nd
production database:
mysql> show databases;
+-+
| Database
31 matches
Mail list logo
