| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> Why do I get error "out of memory" when top says it only uses half of the ram? how can I change this?
<1> if you're using enum fields and you're either expecting 'something', or nothing.. how do you write that 'something', ''?
<2> Hi Guys, please help. Imagine the following national characters in UTF-8: Á and É. I can't enter the first one into my tables!
<2> the second one, and all our other national characters work perfect.
<2> ) CHARACTER SET utf8 COLLATE utf8_bin
<2> TYPE=INNODB;
<1> is there anyway to sort alphabetically
<1> or is that a dumb question
<1> i've been known to ask dumb questions
<3> hello
<3> is there any prefered table type?
<3> I haven't messed with mysql in a while and I see that all my sql code has the MyISAM type on the table
<3> is this the prefered type
<3> or should I use another?
<4> DogWater: yes there is
<4> Acs: yes it is the default table type.
<4> see chapter 14 for details
<4> I prefer the blackhole type <evil grin>
<3> ok
<3> thanks
<5> hehe
<6> hi, I'm trying to install TorrentFlux which requires a mysql db
<6> I made the db, created a new user and did everything correctly
<6> but when I try to login to TorrentFlux, it says that it cannot connect to 'torrent'@'localhost'
<6> any suggestions?
<4> so you made a user called torrent?
<6> yeah
<6> I made it through webmin
<6> Database error: Access denied for user 'torrent'@'localhost' (using p***word: YES)
<6> that is the error I am receiving
<6> I got a similar error when I was installing vbulletin earlier, but somehow that error was resolved
<7> did you edit the config file for torrent flux to reflect the user and p*** perry753 ?
<6> blobaugh, yeah, all the information are filled in correctly...
<6> I tried restarting mysqld
<7> im webmin did you give them mysql access and db access?
<6> the user has all permissions...
<6> how can I give the user mysql and db access?
<7> for mysql itself or for the db in mysql? webmin has two sections you have to add the user in
<6> oh... like "Create Database Permissions"?
<6> I'm saying for the db...
<6> I just added user 'torrent' access to "Any" database with all permissions, and hosts
<7> sorry about that. my batt died
<7> did you figure it out?
<8> hi
<6> blobaugh, still doesn't work :'(
<6> should I try to use 'root' user?
<8> ive got a datetime field that id like to obtain a list of dates that're between a specific date and also a specific time range.. not sure how to do this :(
<8> like i need from 2005-08-01 through 2005-09-01, but also only results between the time range of 07:00 and 15:00
<9> m-00kie: so use the DATE() and HOUR() functions
<10> is 40 fields in a table to large, lol?
<10> fields are small - btw
<7> perry753: no. you just need to figure it out
<7> what does, 'show all grants on torrentflux' say?
<6> blobaugh, ok here is the problem
<6> [root@xeon608 torrent]# mysql -u torrent -p
<6> Enter p***word:
<6> ERROR 1045 (28000): Access denied for user 'torrent'@'localhost' (using p***word: YES)
<6> I can't login
<6> where is show all grants?
<11> cyphor if its needed no
<10> k thanks
<11> have a look at say phpbb's database creation script it has tonns of fields to tables
<12> must go now 1 laptop 500$ 1 desktop 500$ message me if interested on msn at mcsltd2@hotmail.com, aim at ogd443 or yahoo at thishastogotoday
<7> perry753: when you made the user did you put a p***word in?
<6> blobaugh, Yes, I'm trying to redo everything using phpMyAdmin
<6> maybe it's webmin thats the problem
<7> perry753: when you made the user in webmin which button did you click?
<7> webmin is not your problem
<6> uh hold on let me bring back webmin
<6> on the MySQL page, I clicked on user permissions
<6> and then clicked on create new user
<6> then filled in everything with a p***word and I highlighted all permissions
<6> and clicked save
<7> ok. did you change the radio buttons?
<6> yeah
<7> what happens if you do not use -p on the command line?
<6> which -p option? you mean like "mysql -u torrent -p"?
<7> yeah, get rid of -p and tell me what happens
<6> [root@xeon608 phpMyAdmin-2.8.0.1]# mysql -u torrent
<6> Welcome to the MySQL monitor. Commands end with ; or \g.
<6> Your MySQL connection id is 109 to server version: 4.1.12
<6> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
<6> mysql>
<6> webmin says I have a p***word set...
<7> so you do not have a p***word set for you torrent user
<6> let me reset it
<7> well webmin is lying to you
<6> yeah
<6> omg ok time for phpmyadmin
<7> why?
<6> webmin won't do the job?
<7> yes it will
<7> !help set p***word
<13> There is no such command.
<6> I just set it again...
<7> !commands
<13> Commands: bridges, channels, commands, conversation, conversations, country, dict, doc, e, fm, google, help, kick, lookup, m, man, mia, networks, owners, p, p***word, perror, php, plugins, pypi, query, rfc, rtfm, seen, source, spell, status, stfm, syncs, tell, time, toc, top,
<13> weather, who, whois, +ban, +bridge, +connect, +define, +disable, +disconnect, +enable, +forget, +garbage, +gbridge, +ignore, +ignores, +join, +kickban, +loglines, +logoff, +nick, +op, +part, +pkginfo, +prefix, +quiet, +rebuild, +reconnect, +respond, +say, +setpwd, +spill,
<13> +spill, +stfu, +sync, +top10, +top5, +topall, +unbridge, +unignore, *debug, *manhole, *owner, *regenerate, *resetpwd, *upgrade
<7> !m set p***word
<13> set: (Access Control, Stage 1: Connection Verification) : http://dev.mysql.com/doc/mysql/en/Connection_access.html
<7> !m p***word
<13> Incorrect usage. See 'help m'
<7> !help m
<13> Usage: m <user> <keyword> -- Attempts to find a MySQL manual page by keyword search
<7> !m perry753 set p***word
<13> perry753: (SET P***WORD Syntax) : http://dev.mysql.com/doc/mysql/en/SET_P***WORD.html
<6> wait
<7> perry753: you should learn how to use the console. it comes in handy
<7> ive never had any probs with webmin though
<7> maybe erase the user and recreate it
<6> ok
<6> again, there isnt a p***word set to the user
<7> and its still not letting you login?
<6> lemme just use the console...
<6> no
<6> hold
<7> what does the database permissions say in webmin?
<14> Is it possible to copy a table from one database to another?
<15> CSWookie: CREATE TABLE LIKE ... CREATE TABLE ... SELECT. INSERT INTO ... SELECT
<16> CSWookie yes
<15> CSWookie: Lots of ways to do that... not to mention mysqldump.
<6> blobaugh, I set the p***word via console
<16> if you login has access to both db's
<16> read access to one and write to the other
<6> blobaugh, but then when I try and login via console it still has no p***word set
<14> My login does. I really just want the simplest way to get the data. My table is small, and I want to gank my coworkers table, so I will have more data to experiment with.
<7> perry753: login from the console again and do 'use mysql;' then 'select p***word from user where user='torrent';'
<6> ok
<17> what kind of error would i get from doing an insert with null values into a fields that are set for nonnull?
<7> nater: try it and find out
<6> it gives me a table with p***word and the encrypted p***word
<7> then your p***word should be there... what is the command you are running again?
<6> mysql -u torrent
<18> Hi there
<6> i run mysql -u torrent and then it logs in
<1> is there a way to say delete from table where something is something AND anotherthing is something also
<19> of course
<18> If you make a FK constraint with triggers (on delete, on update) when are they called? When the FK is deleted/updated or when the PK is deleted or updated?
<7> DogWater: i think where blah='blah',blah2='blah2'. test it though
<15> DogWater: AND
<15> blobaugh: Not comma.
<18> delete from table where something=something AND somethingelse=somethingelse...
<19> comma is for update ;p
<7> ah, cool, ive never actually done it with delete
<15> enygma: Not in an WHERE clause.
<15> s/an/a
<19> Xgc - just a usual place to use a "foo=bar,bar=baz" kind of thing
<19> ;p
<1> xgc, thanks
<7> perry753: im stumped. it should be working now
Return to
#mysql
or
Go to some related
logs:
ubuntu wpe config
feh ERROR: couldn't load image in order to set bg
funny remake of I Want Candy
#redhat
#ubuntu
#perl
defconstant sbcl quiet
ubuntu Zsh install as default shell
xorg change dpi
#php
|
|