| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> did you check your create priveleges for the user?
<1> is there an SQL statement I can execute to grant a user the privileges necessary to make more databases for himself?
<0> yea
<0> !m FliesLikeALap privileges provided
<2> FliesLikeALap: (Privileges Provided by MySQL) : http://dev.mysql.com/doc/mysql/en/Privileges_provided.html
<0> take a look at the privileges you care to change for the user
<0> remember everything about a users info is in a table itself
<1> well aware
<1> I
<0> so every account privileges are stored in tables
<1> I'm fairly familiar with MySQL privileges, but I am stumped on how to allow a user to create more databases
<0> you have to be root though..
<0> okay
<0> take a look at tables_priv table
<1> that is table privileges though, what does that have to do with a user's ability to create databases?
<0> ddo you know the grant option?
<1> yes
<3> How do i randomly select things from a database?
<0> if you place Privilege of CREATE
<0> it will let hte user create databases erm
<0> let me check
<4> I am thinking of taking the certification test for a mysql developer, or the dba. Where is the 5.0 manual in tar ball format so I can download it? Also are there sample questions somewhere ?
<0> i think I am wrong
<0> one sec let me look at hte docs
<3> i thought CREATE
<1> thank you _m0O
<4> Also, what is the difference between certified developer, and certified DBA?
<3> only let the user create tables?
<1> [for your time]
<0> yea Hit3k
<5> hi there. I keep getting error no. 24 when doing a mysqlhotcopy on my databases - so there are too many files open. How can I tweak my Linux box to allow mysql open more files ?
<0> mysql> INSERT INTO user
<0> -> VALUES('localhost','monty',P***WORD('some_p***'),
<0> -> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
<0> I know its one of those..., But I forgot which :x
<1> yeah _m0O I've been trying different combinations of them for a while, and after giving up is when I asked in here
<1> ah hang on a sec
<1> nope, still can't figure it out
<4> I brute forced it, and used wget on http://mirror.tomato.it/mysql/doc/refman/5.0/en/index.html
<0> CREATE Create_priv databases, tables, or indexes
<0> why wouldn't that work?>
<1> I tried GRANT CREATE DATABASES to username@'localhost' identified by 'p***word' and it said that "databases" was a syntax error
<0> GRANT CREATE to user ....
<1> hang on
<0> there is some confusion in the docs
<0> CREATE Enables use of CREATE TABLE
<0> CREATE Create_priv databases, tables, or indexes
<0> I guess it should work
<1> it doesn't work "grant create to user@host identified by p***word"
<0> The CREATE and DROP privileges allow you to create new databases and tables, or to drop (remove) existing databases and tables. If you grant the DROP privilege for the mysql database to a user, that user can drop the database in which the MySQL access privileges are stored.
<0> is it syntax error?
<1> yes _m0O I understand that, I'm having problems with the syntax of the statement
<1> yes.
<0> GRANT CREATE ON tmp.* TO username@localhost;
<0> erm
<0> wait
<0> you have to have ON
<6> Hey Folks, why is it better to have master/slave replication instead of multi-master replication (other than the caveat regarding autoincrementing values in the docs)?
<0> which you don't have
<1> endikos why would you want master-master ?
<0> FliesLikeALap - you don't have the ON thing I didn't see it earlier
<6> FliesLikeALap: HA Failover without splitting read and write servers
<0> add the ON identifier before the TO
<1> _m0O but what am I supposed to put after the ON ? I want this user to be able to create databases, why in the world would that need an ON specification?
<0> mysql tells us to use ON
<0> GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
<0> ON [object_type] {tbl_name | * | *.* | db_name.*}
<0> TO user [IDENTIFIED BY [P***WORD] 'p***word']
<0> just put *
<0> GRANT CREATE ON * TO user ....
<5> hi there. I keep getting error no. 24 when doing a mysqlhotcopy on my databases - so there are too many files open. How can I tweak my Linux box to allow mysql open more files ?
<0> !perror 24
<2> System error: 24 = Too many open files
<5> i know about that
<0> sorry i was checking if it still works :)
<5> ah :)
<5> right
<5> so can you give me a hint on how to increase the number of allowed files for mysql ?
<0> hmm
<0> when you use the SHOW STATUS Syntax itr will tell you how many files are open
<0> can you check how many files are open now?
<5> 128
<5> currently
<0> :o
<0> are you using MyISAM?
<5> i think so ;-)
<5> at least party
<5> partly
<0> you should hmm
<0> The only place where I would think you could alter the num of files open is in the config file
<5> but it seems not to be a mysql issue really - but rather the filesystem not allowing so many files to be opened
<5> anyway, i could not find a statement in the my.cnf files that might have any effect on this
<0> i thin it is a os issue :
<0> are you using linux?
<5> yes
<0> "Apparently the client *was* running out of file
<0> descriptors and was causing problems in the server and making it
<0> *falsely* report "Error in accept: Too many open files in system"
<0> "
<0> http://mail-index.netbsd.org/netbsd-users/2002/09/02/0000.html
<0> !m funky Not enough file handles
<2> funky: (File Not Found) : http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html
<0> rread that
<0> and do what it tells you to
<7> hello everybody
<0> hi
<5> hmm.. well, i limited the max_connections
<5> and now it gets a little further
<5> so it hangs later in the process of backing up the databases
<5> ;)
<5> which at least is an improvement i guess.
<0> heh
<0> Sorry, I don't know what else I could help with
<7> real short question, how do I connect to mysql from localhost without a pwd?
<7> ...installing first time
<0> mysql -u root -p
<0> prss enter
<0> twice
<5> ;)
<5> right.. thanx anyway.
<7> _m0O: no, access denied
<5> but another question.. how can i determine which conf file a running instance of mysql is using ?
<7> access denied for root@localhost
<7> (using pwd: NO)
<7> vers 3.23
<5> _Thor: did you append the -p option ?
<7> sure, I typed: mysql -u root -p
<7> and hit enter twice
<5> hmmm.. then it's actually supposed to say (using pwd: YES)
<5> ah. okay
<5> do what you actually want to do is recover the root p***word right ?
<7> no, this is a first time installing mysql on this server, I want to go in the prompt to set the grant tables
<7> that's the first thing to do right?
<7> I want to get to the prompt
<5> you might try setting a p***word using mysqladmin p***word <new-p***word>
<7> when I type mysqladmin -u root p***word 'xxx' I get "connect to server at 'localhost' failed
<5> just type the following: mysqladmin p***word <mynewp***word> where <mynewp***word> is your new p***word
<5> dont do a -u root -p
<7> I did... I get "connect to server at 'localhost'failed
<5> did it give a reason ?
<7> next line says: error: access denied for user: root@llocalhost (using pwd: NO)
<8> hi...I am trying to get a new installation of mysql 4.1 to work with webmin...I am getting this error when I try to log on using webmin: The full MySQL error message was : connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using p***word: YES)' ?
<8> I set the p***word for root in mysql...
<8> but it does not seem to work on webmin when I use name root ?
<9> It works okay when you connect from the command line?
<8> what is the command I should use to connect...
<8> I am a little new and just installed it
<9> mysql -u root -p
<8> sec
<8> [root@NSC002 /]# mysql -u root -p
<8> Enter p***word:
Return to
#mysql
or
Go to some related
logs:
filesystem openMosix 2.6.16
captive-ntfs mmap
build movie from single images linux
gparted ntfs unlock
ubuntu doesnt use swap
rmdir /dev/.udev failed
#linux
nethogs windows
ubuntu the underlying authorization mechanism (sudo) does not allow
phpadmyn fedora
|
|