Re: can't authenticate ssl user account

2015-07-21 Thread Tim Dunphy
Hi Reindel, you client configuration shows no indication for SSL, i see it in my.cnf > only in the [mysqld] section and remember when you initrialize replication > you need to specify it there too > > i doubt there is anything to change the logging but since you *know* what > that user requires th

Re: can't authenticate ssl user account

2015-07-21 Thread Reindl Harald
Am 21.07.2015 um 05:03 schrieb Tim Dunphy: I see absolutely NO indication as to why the login for the 'slave2' user (that requires SSL) is failing So my questions are 1) how to I bump up the verbosity on the logs so I can get an indication as to why this is failing? 2) what is the best way to t

can't authenticate ssl user account

2015-07-20 Thread Tim Dunphy
Hey all, I need to setup replication via SSL. 2 nodes master/master for H/A. Then 2 slave nodes for backup. Node 3 will slave off of node 1, and node 4 will slave off of node 2 for redundant backups. Nodes 3 & 4 will store backups to a directory mapped to S3 via S3FS. All nodes are physical. We'

Re: secure user name for MySQL account?

2012-09-24 Thread Arthur Fuller
27;s true that our last > big security change was the enhanced password hash function introduced in > 4.1 we have not been completely insensitive to the needs of our customers. > For example, check out the list of account and security improvements > arriving in MySQL 5.6 > http://d

Re: secure user name for MySQL account?

2012-09-24 Thread Shawn Green
prove in this respect. While it's true that our last big security change was the enhanced password hash function introduced in 4.1 we have not been completely insensitive to the needs of our customers. For example, check out the list of account and security improvements arriving in MySQL

Re: secure user name for MySQL account?

2012-09-24 Thread Arthur Fuller
On this note, one thing that really bugs me about MySQL passwords is the inability to use special characters. In the SQL Server world, I let users choose their own passwords, but obeying these rules: It cannot be a dictionary word or sequence of words. It must contain at least one numeric digit. I

Re: secure user name for MySQL account?

2012-09-24 Thread Johan De Meersman
- Original Message - > From: "Rajeev Prasad" > > I am considering using cryptic username for accessing and working on > a database on my MySQL installation. can anyone with experience > provide some suggestion pl? Why would you make your life hard by using cryptic usernames? Have the u

secure user name for MySQL account?

2012-09-24 Thread Rajeev Prasad
I am considering using cryptic username for accessing and working on a database on my MySQL installation. can anyone with experience provide some suggestion pl? in documentation, i only see that it can be 16 char long. how complex it can be? any side effects/bugs of username complexity? can I us

Re: MySQL install on OS X Lion does not create root account

2011-11-15 Thread Michael Dykman
> > I also followed various instructions in the MySQL documentation for > resetting lost passwords. But the results persuaded me that the problem is > something else:  the installer does not create a root account or a mysql > account in the user table. Thus the update command for resett

MySQL install on OS X Lion does not create root account

2011-11-15 Thread Martin Mueller
installer does not create a root account or a mysql account in the user table. Thus the update command for resetting the root password executes correctly but update 0 rows. And logging in with the skip-grants-table lets you address some queries to the mysql user table. "Select count(user)

Re: Remove 'debian-sys-maint' Account?

2010-03-03 Thread Johan De Meersman
On Tue, Mar 2, 2010 at 7:15 PM, Carlos Williams wrote: > 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 > 

Re: Remove 'debian-sys-maint' Account?

2010-03-03 Thread nixofortune
Hi ALL, You will find all the details you need to set up debian-sys-maint account under /etc/mysql/debian.cnf GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE

Re: Remove 'debian-sys-maint' Account?

2010-03-03 Thread Ian Simpson
Hi Carlos, The debian-sys-maint account is used for two things that I am aware of: 1) the /etc/init.d/mysql stop command uses it to perform a controlled shutdown of MySQL. 2) on execution of /etc/init.d/mysql start, it uses this account to run a CHECK TABLE on all of your tables The first

Remove 'debian-sys-maint' Account?

2010-03-02 Thread Carlos Williams
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 ca

RE: setting up root account

2009-08-13 Thread Jerry Schwartz
com >Subject: setting up root account > >Okay it appears my mysql database is simply screwed up. > >I am attempting to rebuild the root account and privileges and now I >cant do anything. How do I rebuild the root account with proper >privileges and the grant option. > &g

Re: setting up root account

2009-08-13 Thread muhammad subair
Maybe this thread [0] is useful for you. http://forums.mysql.com/read.php?10,70927,71012#msg-71012 On Thu, Aug 13, 2009 at 1:48 PM, Noah Garrett Wallach wrote: > Okay it appears my mysql database is simply screwed up. > > I am attempting to rebuild the root account and privileges

setting up root account

2009-08-12 Thread Noah Garrett Wallach
Okay it appears my mysql database is simply screwed up. I am attempting to rebuild the root account and privileges and now I cant do anything. How do I rebuild the root account with proper privileges and the grant option. I am thinking: mysql -u root use mysql; GRANT ALL

Re: Account Problems. Can't register server with new account

2007-11-06 Thread AlejandraB
ed for user 'usuario1'@'192.168.20.5' > +--+--+ > | Host | User | > +--+--+ > | 192.168.20.5 | usuario1 | > +--+--+ > > > To Update: > mysql> update user set Host="localhost"

Re: Account Problems. Can't register server with new account

2007-11-06 Thread Russell E Glaue
> > I have mysql cluster installed and I'm trying to start the mysql server with > a new user account recently created, and I'm having trouble accessing the > server with the new account. > > [EMAIL PROTECTED] bin]# ./mysql -u usuario1 -p > Enter password: > ERR

Account Problems. Can't register server with new account

2007-11-03 Thread AlejandraB
Good evening. I have mysql cluster installed and I'm trying to start the mysql server with a new user account recently created, and I'm having trouble accessing the server with the new account. [EMAIL PROTECTED] bin]# ./mysql -u usuario1 -p Enter password: ERROR 1045 (28000): Acc

Re: Deleted Root Account

2007-05-07 Thread Baron Schwartz
up in smoke when I removed mysql_server. They're all intact. If this happens again, there are even easier ways to solve it: 1) Ubuntu has a built-in debian-sys-maint administrative account you can use to restore the root account. 2) There is a good discussion about this in the manual:

Re: Deleted Root Account

2007-05-05 Thread B. Keith Murphy
I have had exactly the kind of trouble you are talking about. Sorry I didn't see the messages until just now. Had to manually remove crap too even though I purged (rpms - centos I think). Hopefully this will help others down the road. Keith John Kebbel wrote: Even though I complet

Re: Deleted Root Account

2007-05-05 Thread John Kebbel
Even though I completely removed everything I could find related to MySQL in Synaptic Package Manager, a folder still remained at /var/lib/mysql/ containing all my old table information. If that info hung around, it seemes logical to assume the Grants table were still somewhere interfering

Re: Deleted Root Account

2007-05-05 Thread John Kebbel
The Synaptic checkbox menu has a Mark for Removal and Mark for Complete Removal. Complete Removal seems to be same as Purge; when I look at details, it says the configuration files are being removed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Deleted Root Account

2007-05-05 Thread Peter Teunissen
s, (2) Set passwords for the new accounts, and then (3) Displayed the grants for these new accounts on the command line. The last few lines of code took advantage of a new security tip I had just learned--change the name of the root account to something unguessable and then give the disguised root acc

Deleted Root Account

2007-05-05 Thread John Kebbel
d then (3) Displayed the grants for these new accounts on the command line. The last few lines of code took advantage of a new security tip I had just learned--change the name of the root account to something unguessable and then give the disguised root account a new password. I was running this

Re: account that can only do backup

2006-12-14 Thread Visolve DB Team
Team - Original Message - From: "Bing Du" <[EMAIL PROTECTED]> To: Sent: Thursday, December 14, 2006 12:26 AM Subject: account that can only do backup > Hi, > > I want to create a MySQL user account that can only do database backup but > nothing else. Wha

Re: account that can only do backup

2006-12-13 Thread Bing Du
> On 12/13/06, Bing Du <[EMAIL PROTECTED]> wrote: >> Hi, >> >> I want to create a MySQL user account that can only do database backup >> but >> nothing else. What privileges does such an account need? >> >> I'm having trouble with connectin

Re: account that can only do backup

2006-12-13 Thread Daniel da Veiga
On 12/13/06, Bing Du <[EMAIL PROTECTED]> wrote: Hi, I want to create a MySQL user account that can only do database backup but nothing else. What privileges does such an account need? I'm having trouble with connecting to mysql.com to look at the documents. It's just

account that can only do backup

2006-12-13 Thread Bing Du
Hi, I want to create a MySQL user account that can only do database backup but nothing else. What privileges does such an account need? I'm having trouble with connecting to mysql.com to look at the documents. It's just spinning forever. Actually, the connection to mysql.com

Starting Mysql from unix root account with --user=mysql

2006-08-31 Thread Duhaime Johanne
I have a very simple question about starting mysql. I start manually the server under the unix account "mysql" with the following: /seqweb/mysql4/bin/mysqld_safe --user=mysql & in order to get the unix user "mysql" to run the process. I get the following with "p

How to keep account independent in replication

2006-02-23 Thread leo huang
Hi, How can I keep the account of MySQL independent in replication? We have two MySQL 4.1.18 nodes: A and B. B replicate A. We want that the account in A is independent. That is to said, it would not affect the account in B when we add or delete the account in A. We add the following option in

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
Incoming from Paul DuBois: > At 18:50 -0600 10/2/05, s. keeling wrote: > > > >Groan. More stuff to learn, configure, maintain, and memorize. I'm > >trying to replicate Unix's "root vs. mere user" security paradigm in > > I think your analogy is flawed. If you really want the root vs mere > user

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread Paul DuBois
At 18:50 -0600 10/2/05, s. keeling wrote: Incoming from Paul DuBois: At 16:39 -0600 10/2/05, s. keeling wrote: > >The admin account, with no password, doesn't function at all. perl >programs appear to ignore ~/.my.cnf forcing me to open() them and >slurp username and

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
Incoming from Paul DuBois: > > At 16:39 -0600 10/2/05, s. keeling wrote: > > > >The admin account, with no password, doesn't function at all. perl > >programs appear to ignore ~/.my.cnf forcing me to open() them and > >slurp username and password that way.

Re: ~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread Paul DuBois
I think I'd probably set up aliases that invoke mysql or mysqladmin with a --defaults-extra-file option that contains the username/password for the appropriate account. At 16:39 -0600 10/2/05, s. keeling wrote: I've checked everywhere I can find (Paul DuBois' MySQL, ML archives

~/.my.cnf syntax for multiple MySQL user accounts per login account?

2005-10-02 Thread s. keeling
ata. I've four MySQL related accounts: root, admin, keeling, and sbk. root is the root mysql user (which I'd prefer to leave alone once the rest is working, which it mostly is). admin is just for trivial mysqladmin stuff. keeling is a full blown admin account able to create and

Re: radius account management using sql

2005-05-05 Thread Rhino
2005 12:53 PM Subject: radius account management using sql > Hello, > We have radius server and using mysql. I would like to determine > who are the users > who have not login to our dialup server for over six months and then > disable the account > In the example below, I&#

radius account management using sql

2005-05-05 Thread Allan P. Magmanlac
Hello, We have radius server and using mysql. I would like to determine who are the users who have not login to our dialup server for over six months and then disable the account In the example below, I'm just using > 10 days mysql> SELECT distinct username,framedipaddress,ac

RE: MySQL account permissions

2005-03-28 Thread Tom Crimmins
On Monday, March 28, 2005 15:07, Philippe Reynolds wrote: > Hi, > > I've just create an account and given it all privileges for > "database_name.*". However when I try to 'load data infile' it > tell's me that the account doesn't permit it. >

Re: Can't login mysql with root account!

2004-03-31 Thread Victor Medina
Hi! [EMAIL PROTECTED] wrote: I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site) into my Debian v3.0r2 box! After finished installing, i had followed the instruction here to change root's password but right after --8< Try to do a login without using passwor

Re: Can't login mysql with root account!

2004-03-30 Thread jeffrey_n_Dyke
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site) into my Debian v3.0r2 box! After finished installing, i had followed the instruction here to change root's password but right after this action, i can't login to mysql any more! I had also try to change owners

Can't login mysql with root account!

2004-03-30 Thread wood_flower
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian Packages Site) into my Debian v3.0r2 box! After finished installing, i had followed the instruction here to change root's password but right after this action, i can't login to mysql any more! I had also try to change owners

User Account errors on new installation

2004-02-13 Thread Russ Myrick
I have MySQL ver. 4.0.18 binarys for windows installation.  I just finished installing mysqld-max-nt as a service on a WinXP box yesterday afternoon.  Using the MySQL Administrator client/utility GUI, I configured the anonymous and root Users, then added a superuser level account for myself

root account automatically created for a "GCW" host???

2004-01-18 Thread Hontvari Jozsef
Hello, I installed mysql 3.23.58 a few days before on a clean Windows 2003 machine, but today I noticed that in the user table there are two additional entries (above the usual localhost root and localhost ) which makes me nervous. Does anybody know what are the gcw root and gcw accounts? I don'

RE: The MYSQL account on Linux

2003-11-18 Thread Myhre, Julie
Hi, Thanks - I'm familiar with the passwd command...this was actually a mysql question, as I wasn't asking how to change the password, but rather: would changing the password affect anything that was part of the processes supporting the database? I've been bitten by account passwo

Re: The MYSQL account on Linux

2003-11-18 Thread gerald_clark
Why do you want to login as mysql? This really is not a mysql question, but while logged in as root, enter the command: passwd mysql Myhre, Julie wrote: Hello, I started my current job with MySQL already installed on a Linux box, and no one seemed to know what the mysql account's password was

The MYSQL account on Linux

2003-11-18 Thread Myhre, Julie
Hello, I started my current job with MySQL already installed on a Linux box, and no one seemed to know what the mysql account's password was I want to know/change the Linux password so I can login as mysql. So far it has been fine to become root and su to mysql, as I don't do it THAT often, b

Re: mysql account

2003-10-05 Thread Wang Feng
Thanks Paul. Fully understand!! cheers, feng - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 4:38 AM Subject: Re: mysql account > At 14:00

Re: mysql account

2003-10-05 Thread Paul DuBois
At 14:00 +1000 10/5/03, Wang Feng wrote: > If you deleted the rows with a DELETE statement, you'll need to also issue a FLUSH PRIVILEGES statement to cause the server to reread the grant tables. In order to try the FLUSH PRIVILEGES statement, I inserted a new user account into the 

Re: mysql account

2003-10-04 Thread Wang Feng
Paul, > I am assuming that the 'alan' account that you're planning to use has > all privileges. Otherwise, you will find after flushing the privileges > that you'll no longer be able to administer your server without starting > it with the --skip-grant-tables opti

Re: mysql account

2003-10-04 Thread Wang Feng
e - From: "Thada, Shantalaxmi (NIH/CC/PET)" <[EMAIL PROTECTED]> To: "'Wang Feng '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 05, 2003 5:57 AM Subject: RE: mysql account > > do u have a .my.cnf in c:\ dir or c:\windows d

Re: mysql account

2003-10-04 Thread Paul DuBois
At 4:35 +1000 10/5/03, Wang Feng wrote: Hi, folks. I use WinXP + MySQL. I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases. T

RE: mysql account

2003-10-04 Thread Thada, Shantalaxmi (NIH/CC/PET)
do u have a .my.cnf in c:\ dir or c:\windows dir ? from DOS when u issue a mysql command it usually picks up the username and password from the .my.cnf file. - Shanta -Original Message- From: Wang Feng To: [EMAIL PROTECTED] Sent: 10/4/2003 2:35 PM Subject: mysql account Hi, folks

mysql account

2003-10-04 Thread Wang Feng
Hi, folks. I use WinXP + MySQL. I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases. The problem is that I still can login

using mysql easily from user (no root, no mysql system account) space

2003-07-11 Thread Eduardo Pérez Ureta
I'm looking for an easy way to use mysql from user (no root, no mysql system account) space. I don't want the user of my application to have to use a password to connect to the database. I want to have multiple databases to differentiate between programs. Is libmysqld the way to go? Is

Re: Why does auto increment not take into account deleted rows?

2003-06-03 Thread Paul Najman
ed' number then your 'serial number' is not really associated with the record. Best wishes, Paul Najman [EMAIL PROTECTED] - Original Message - From: "Daniel Crompton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 02, 2003 5:18 PM Su

Re: Why does auto increment not take into account deleted rows?

2003-06-03 Thread Egor Egorov
"Daniel Crompton" <[EMAIL PROTECTED]> wrote: > I have one column as an auto increment for adding numbers: > > 1 > 2 > 3 > 4 > 5 > > If i delete row 3 then add a new row and view the results i get: > > 1 > 2 > 4 > 5 > 6 > > As you can see 3 has been deleted and its now added 6! > > Is this norm

Re: Why does auto increment not take into account deleted rows?

2003-06-03 Thread William R. Mussatto
> I have one column as an auto increment for adding numbers: > > 1 > 2 > 3 > 4 > 5 > > If i delete row 3 then add a new row and view the results i get: > > 1 > 2 > 4 > 5 > 6 > > As you can see 3 has been deleted and its now added 6! > > Is this normal?. How can i get it to always display numbers i

RE: Why does auto increment not take into account deleted rows?

2003-06-03 Thread Mike Hillyer
That is normal and you do NOT want it to display numbers in sequence. Lets say I use auto-increment column for primary key, lets also say that I made a mistake while coding and deleted someone's account (account #3) from the account table, but forgot to delete the corresponding entry fro

Why does auto increment not take into account deleted rows?

2003-06-03 Thread Daniel Crompton
I have one column as an auto increment for adding numbers: 1 2 3 4 5 If i delete row 3 then add a new row and view the results i get: 1 2 4 5 6 As you can see 3 has been deleted and its now added 6! Is this normal?. How can i get it to always display numbers in this column in sequence. TIA

Re: BUG: NT service account and defaults file

2003-04-03 Thread miguel solorzano
At 17:04 02/04/2003 +0100, Simon Tyler wrote: Hi, Looking at the code (3.23, 4.0 and 4.1) it looks as if it is getting confused in the main (in mysqld.cpp) and just calls Service.Init without loading the default file. Doing the above without a service name works OK, doing it without over-riding

BUG: NT service account and defaults file

2003-04-02 Thread Simon Tyler
I've been trying to install MySQL (3.23.55) as a named NT service and using a specified defaults file and I can't get it to work. The source code has the example: mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini in it. The results in a service ImagePath of C:\mysql\bin\mysql

RE: completely resetting root account

2003-03-25 Thread Dan Wright
need to rebuild everything though... this is a good learning experience for you! Dan > Okay, so this question may not indicate I'm smart enough to > administer MySQL > and I should slowly back away from the keyboard, but here goes... > > When using phpMyAdmin, I attempted to dupl

completely resetting root account

2003-03-25 Thread Alex Heizer
Okay, so this question may not indicate I'm smart enough to administer MySQL and I should slowly back away from the keyboard, but here goes... When using phpMyAdmin, I attempted to duplicate the root account, which had access to everything. I accidentally selected the wrong radio button,

Re: Running as a user account on W2K

2003-03-13 Thread Simon Tyler
ge from "Simont Tyler" <[EMAIL PROTECTED]> at 12-Mar-2003 12:58:35 -- >Hi, > >I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld >service as a user account rather than the local system account. This worked fine in >3.23.43 but ha

Running as a user account on W2K

2003-03-12 Thread Simont Tyler
Hi, I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service as a user account rather than the local system account. This worked fine in 3.23.43 but has stopped working since the upgrade. The error I get is 2186, which seems to be "service failing to

re: account turned on again

2003-02-10 Thread Amber Williams
membership. We have also included 9 free movies for your enjoyment. Thanks Account Dept. Amber Williams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: [NEWBIE] Master Account

2002-09-30 Thread Clayburn W. Juniel, III
On Monday, September 30, 2002, at 04:34 24h, Stéphane Pinel wrote: > > I've just installed MySQL on a MacOS X 10.2 system. Everything is OK > but I > can't find how I can login as a master to create users and give > privileges ? > > Thanks. With the server running you first need to give "roo

re: [NEWBIE] Master Account

2002-09-30 Thread Victoria Reznichenko
Stéphane, Monday, September 30, 2002, 2:34:17 PM, you wrote: SP> I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I SP> can't find how I can login as a master to create users and give privileges ? It's not so difficult. You should connect to the MySQL server as root:

[NEWBIE] Master Account

2002-09-30 Thread Stéphane Pinel
I've just installed MySQL on a MacOS X 10.2 system. Everything is OK but I can't find how I can login as a master to create users and give privileges ? Thanks. -- S.PINEL - Before posting, please check: http://www.mysql.c

Re: Root account locked out

2002-07-22 Thread Egor Egorov
Leonard, Saturday, July 20, 2002, 4:50:32 PM, you wrote: LM> mysql version 3.23.41 On Redhat 7.2 LM> I was trying to get this setup so I could limit access to future LM> databases, LM> and I think I locked my root account out. LM> I tried restarting with "/etc/rc.d/in

Re: Root account locked out

2002-07-22 Thread Håkon Eriksen
"Leonard Miller" <[EMAIL PROTECTED]> writes: > mysql version 3.23.41 On Redhat 7.2 > I was trying to get this setup so I could limit access to future > databases, > and I think I locked my root account out. > I tried restarting with "/etc/rc.d/init.d/mysq

Re: Root account locked out

2002-07-22 Thread Håkon Eriksen
"Leonard Miller" <[EMAIL PROTECTED]> writes: > mysql version 3.23.41 On Redhat 7.2 > I was trying to get this setup so I could limit access to future > databases, > and I think I locked my root account out. > I tried restarting with "/etc/rc.d/init.d/mysqld

RE: Problem with User Account - access denied

2002-04-28 Thread Christina Baldry
Isnt it GRANT ALL ON college.* TO someuser identified BY "somepassword"; -Original Message- From: J [mailto:[EMAIL PROTECTED]] Sent: Sunday, 28 April 2002 2:22 AM To: [EMAIL PROTECTED] Subject: Problem with User Account - access denied I created and user, like below, usin

Problem with User Account - access denied

2002-04-27 Thread J
I created and user, like below, using mysql on my Linux machine (Linux-Mandrake 8.1) to access a database called college: GRANT ALL ON college.* TO someuser BY "somepassword"; But I'm denied access even from localhost. I tried the following too: GRANT ALL ON college.* TO someuser@% BY "somepass

Re: Trouble Connecting With Non-Admin Account Via PHP

2002-04-16 Thread Zyxian
My problem is fixed. I only grant'ed user@localhost. What I needed, and have done, is grant'ed [EMAIL PROTECTED] Once I did that everything worked. Zyxian On Tue, 16 Apr 2002 09:38:19 -0700, Zyxian wrote: Hello. When trying to connect to a database through php using a user that has been gran

Trouble Connecting With Non-Admin Account Via PHP

2002-04-16 Thread Zyxian
Hello. When trying to connect to a database through php using a user that has been granted all rights to the database I get the "Can't connect to database" error. If I use the Admin's name and password I have no trouble connecting through the php page. From a shell prompt I can connect to mysql

Re: How to check disk space used for a mysql account

2002-01-25 Thread Jeremy Zawodny
On Wed, Jan 23, 2002 at 06:15:38PM -0500, Alex Shi wrote: > > How to check disk space been used for all of the tables of a > specific mysql account? Depends what you mean. MySQL "accounts" don't necessarily map to tables or databases, so how can you properly account

How to check disk space used for a mysql account

2002-01-24 Thread Egor Egorov
Alex, Thursday, January 24, 2002, 1:15:38 AM, you wrote: AS> How to check disk space been used for all of the tables of a specific AS> mysql account? In general, you cannot check that. But tables are just files residing in the datadir - you can check the size of the files. AS

How to check disk space used for a mysql account

2002-01-23 Thread Alex Shi
How to check disk space been used for all of the tables of a specific mysql account? Thanks in advance for all answer! Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

help please!-- i -hate imail! *l* which is why ask a cc to my reg account

2001-12-25 Thread Webmaster
Back | Next | Reply | Reply All | Forward | Delete | Move To database / sql/ mysql Message: 1 of 11122 Printable Version From: [EMAIL PROTECTED] Save Address Date: 25 Dec 2001 15:14:07 - To: "Webmaster" <[EMAIL PROTECTED]> Subject: Re: Re: Need Help bad!.. today.. of a

Account Management Question

2001-11-11 Thread Gary Huntress
e, drop ON somedatabase.* TO 'theuser'@'%' IDENTIFIED BY 'somepassword' and then subsequently revoke their rights (to temporarily suspend access to the db) REVOKE all on somedatabase.* from 'theuser'@'%' Can I then re-enable their account by issuing:

User account

2001-09-04 Thread Ruben Domene
Hi all. I am beginner in mysql. I have installed mysql 3.23 under linux, and i want create one user for accessing to mysql. I have created the user: "gestor". If i am root when i execute: mysql i recived a error message: "ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)"

Returned mail: Account "e_business" does not exist

2001-08-20 Thread GetResponse Postmaster
We were unable to deliver information because: Account "e_business" does not exist The FREE autoresponder service is provided by GetResponse.com >>> http://www.GetResponse.com/ - Transcript of session follows - ... while talking to getresponse.com >>&g

An E-mail account for 2 years, 5 years, for life ? Avenger Mail System is for you !

2001-08-15 Thread ams
Hello, I will like to present you, very quickly, with a new Internet service that i will be putting on line in a few days. Do you want an account Mail independent of your FAI or ISP ? What ever your reasons, Avenger Mail System is for you. Avenger mail System is like Msn, Hotmail, etc

Re: account?

2001-08-01 Thread Grigory Bakunov
Date |Tue, 31 Jul 2001 21:03:23 -0400 >From |[EMAIL PROTECTED] Hello! I> say i am running a server with mysql and phpmyadmin and i have some I> dbs (including of course the mysql db)... I> so when someone says to "set them up a 'MySQL account'" what exactly I&g

Re: account?

2001-08-01 Thread Werner Stuerenburg
. August 2001, 03:03:23: > say i am running a server with mysql and phpmyadmin and i have some > dbs (including of course the mysql db)... > so when someone says to "set them up a 'MySQL account'" what exactly > do they

account?

2001-07-31 Thread ididdy
say i am running a server with mysql and phpmyadmin and i have some dbs (including of course the mysql db)... so when someone says to "set them up a 'MySQL account'" what exactly do they mean? and how do i do it? tia

Re: mysql "account"? account on "mysql"?

2001-07-31 Thread Jeremy Bussard
On Tuesday 31 July 2001 08:40, [EMAIL PROTECTED] wrote: > say i am running a server with mysql and phpmyadmin and i have some > dbs (including of course the mysql db)... > > so when someone says to "set them up a 'MySQL account'" what exactly > do they mean?

mysql "account"? account on "mysql"?

2001-07-31 Thread ididdy
say i am running a server with mysql and phpmyadmin and i have some dbs (including of course the mysql db)... so when someone says to "set them up a 'MySQL account'" what exactly do they mean? and how do i do it? tia

Re: Root account cannot access Mysql

2001-06-14 Thread Wouter de Jong
On Wed, Jun 13, 2001 at 04:56:23PM -0400, RIDLEY, JAMES A. (AIT) wrote: Hi, > I somehow locked out the root account from MySQL. How can I get access back > as root on the Unix system? Try this : /path/to/mysql-directory/libexec/mysqld --skip-grant-tables In a second term, just run my

Root account cannot access Mysql

2001-06-13 Thread RIDLEY, JAMES A. (AIT)
I somehow locked out the root account from MySQL. How can I get access back as root on the Unix system? James A Ridley System Administrator AIX ITO Midrange Support Ameritech/SBC Telecommunications Inc. (317)265-4252 work (317)673-3670 pager

Re: MySQL Installation in a user account

2001-05-04 Thread Mohamad Ilhami
On Sat, 5 May 2001, David Loke wrote: > Hi Guys! > > I am a web server system administrator. I would like to enable the users of > my server to be able to install MySQL individually. That means each user > will have their individual MySQL root access. And from there, their PHP can > connect to t

MySQL Installation in a user account

2001-05-04 Thread David Loke
Hi Guys! I am a web server system administrator. I would like to enable the users of my server to be able to install MySQL individually. That means each user will have their individual MySQL root access. And from there, their PHP can connect to their MySQL db. Is that possible? Rgds --

Re: new mysql account

2001-01-26 Thread Boril Yonchev
GRANT USAGE ON table.* TO user@localhost; GRANT select, insert, delete, update ON table.* TO user@localhost; Boril - Original Message - From: "Mac Martine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 26, 2001 3:13 AM Subject: new mysql acc

Re: new mysql account

2001-01-25 Thread Jeremy D. Zawodny
On Thu, Jan 25, 2001 at 07:13:54PM -0600, Mac Martine wrote: > how do i set up another mysql account after setting up the root > account. i used mysqladmin to set up my root account, now i want to > set up a remotye account to access files on my remote server, right? > so i cant fi

new mysql account

2001-01-25 Thread Mac Martine
how do i set up another mysql account after setting up the root account. i used mysqladmin to set up my root account, now i want to set up a remotye account to access files on my remote server, right? so i cant figure out how to set up another account. i even tried uninstalling and re

new mysql account

2001-01-25 Thread Mac Martine
how do i set up another mysql account after setting up the root account. i used mysqladmin to set up my root account, now i want to set up a remotye account to access files on my remote server, right? so i cant figure out how to set up another account. i even tried uninstalling and re