I wish you all a very happy new year
Brasil, 2004
This message was sent using IMP, the Internet Messaging Program.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
Hello !
I hope all is good with you.
It's a Red Hat Linux 8 with latest version of mysql.
I'm used to using RPMs and uninstalling with rpm -e,
however, this time a binary version of mysql was used
& have got no idea how to uninstall it completely off
the system.
Been looking over the Internet & n
Hi,
I'm trying to compile mysql 3.23.55.
Some info:
>uname -a
Linux atlas 2.4.20 #1 Sat Feb 1 10:39:59 CET 2003 i586 unknown
glibc with libpthreads 2.3.1
> gcc -v
Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/3.2.1/specs
Configured with: ./configure --prefix=/usr --sysconfdir=/etc --lo
Hi,
Compilation of mysql 3.23.55 fails ONLY when using "--with-mysqld-ldflags=-all-static"
results in broken mysqld.
Segmentation fault?
Resolving stack trace:
0x808f4d4 _Z15handle_segfaulti + 404
0x81bc67a __pthread_sighandler + 122
0x81ceb4d __strtol_internal + 1421
0x8096cf6 _Z17add_fie
Hi Robert, are you using the extended parameters to increase the jvm heap
memory ?
ie.
java -Xms256m -Xmx512m
Carlos
On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote:
>
> Getting this error from JDBC while inserting a VERY large VARBINARY or
> MEDIUMTEXT field, ~250M
And whats the size of your "max_allowed_packet" variable ?
Carlos
On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote:
>
> I am, the java heap is set to 2G. But I don't think it is my java
> process that is running out of memory, I believe it is the MySQL serve
to the java list, maybe Mark can reserve a liitle time
from the Mysql Users Conference and give us some feedback.
Carlos
On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote:
>
> It's not set, but I am streaming the LOG to the server, would max packet
> impact this situati
generally speaking joins are always based on primary keys, so, if
you have already defined the primary keys there is an index associated with
the columns of that primary key (just remember that order matters), so the
join use the index and not the whole table.
Hope this helps.
Carlos
On 8/10/06, Ra
innodb as you main engine i suggest the advice of 80% of
ram, obviously it depends of the current load in the server; if you are
running ie. an application server you would have to divide the ram according
to each needs.
Carlos.
On 8/15/06, Shaun Adams <[EMAIL PROTECTED]> wrote:
I'
Besides some recent change on the engine, i remember that the initial
size is 0 because the metadata remains on the main ibdata file(s), and
grows as needed, there is no specific range of extending.
Carlos
On 9/25/06, Takanobu Kawabe <[EMAIL PROTECTED]> wrote:
Hello.
In InnoDB tables
It only works with engines that support transactions like innodb and
solid, i strongly sugget to read these links from the manual.
http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html
Carlos
On 9/25/06, [EMAIL
words.
Carlos
On 9/26/06, Curious George <[EMAIL PROTECTED]> wrote:
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db < 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: Yo
Only if you had enabled the "log" or "bin-log" options, and the log's
history contains the information you need (depending on the log's
creation date).
Carlos
On 11/7/06, Eric Lommatsch <[EMAIL PROTECTED]> wrote:
Hello,
I have accidently droped a table
How come this doesn't work?
Wp_photos.photo = IMG_1234.JPG
Pixelpost_pixelpost.headline = /this/path/to/directory/IMG_1234.JPG
So I need to just match the latter-bit of the file.
update pixelpost_pixelpost,wp_posts,wp_photos
set
pixelpost_pixelpost.headline=wp_posts.post_title,pixelpost_pi
MMENT ON COLUMN products.product_id IS 'Foo';
Thanks in advance
Carlos Savoretti.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ums'.
Sorry for my ignorance but I greatly appreciate any and all assistance
to my question above!
--
Carlos W.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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.
>
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 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
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, 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
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:
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
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.
Carlos
On 5/14/2009 5:28 PM, Carlos Williams wrote:
I noticed today that I strang
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
>
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.
Carlos
On 5/14/2009 5:39 PM, Carlos Williams wrote:
On Thu, May 14, 2009
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 chec
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
On 5/14/2009 5:55 PM, Carlos Williams wrote:
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.unixsl
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...@
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 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
1 | 0 |1 | Carlos Williams | |
j...@mdamusic.com | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@mdamusic.com | | | NULL
| 0 | 2 |
|
1 | 0 |1 | Carlos Williams | |
car...@ideorlando.org | | | --
Carlos | 0 | 1 |
| 2 | 0 |1 | carlos | |
car...@ideorlando.org | | | NULL | 0 |
2 |
|
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
, obviously a nice development IDE like Eclipse or Netbeans :)
Carlos Proal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
You have to take a look on the error log, a file named hostname.err
(hostname=your machine name) and should be located inside
the mysql dir on the xammp dir.
That file will give an insight about the problem, or you can post the
error here to get help.
Carlos
On 7/11/2009 11:52 AM, Gary
Take a look on the my.ini to see if there is something wrong (maybe a
path pointing to a missing place or memory setting bigger than your
actual RAM)
Carlos
On 7/11/2009 12:17 PM, Gary wrote:
Not sure if this is it, it was the only .err file that I have. Also this
seems to be the latest
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
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
les integrity) if it is, then
restore the default value so the next restart would make the recovery if
neccesary.
Hope this helps.
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Did you deleted the data dir (inside Program Files) after uninstall ?? i
think that is was not empty and when the new install tries to set up
finds it and get messy (maybe because the 32 and 64 bit issue).
Carlos
On 7/13/2009 11:07 PM, Edward Diener wrote:
I had previously installed the 64
Another thing you can do is simply erase the innodb logs. If the dbms
really was shutdown properly then the logs are useful,
they will be recreated again and you can go forward with your demo.
Carlos
On 7/14/2009 6:23 PM, Daevid Vincent wrote:
Not sure what you mean "start it agains
Uppps i mean...useless instead of useful.
On 7/14/2009 7:11 PM, Carlos Proal wrote:
Another thing you can do is simply erase the innodb logs. If the dbms
really was shutdown properly then the logs are useful,
they will be recreated again and you can go forward with your demo.
Carlos
On 7
se are not relevant for
your purpose, right ?
Carlos
On 7/14/2009 9:08 PM, Daevid Vincent wrote:
-Original Message-----
From: Carlos Proal [mailto:carlos.pr...@gmail.com]
Sent: Tuesday, July 14, 2009 5:13 PM
Another thing you can do is simply erase the innodb logs.
If the dbms
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
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!
Are you sure that root has granted access to connect remotely ??
Carlos
On 8/4/2009 3:09 PM, Hugo Leonardo Ferrer Rebello wrote:
Hello Guys,
I have a big doubt.
I'm trying to access the mysql database remotely, but I can't.
I have changed the skip-networking option
This might help
http://dev.mysql.com/doc/refman/5.0/en/repair.html
Carlos
On 8/10/2009 11:51 PM, Ron wrote:
Hi All,
why do i have this error. i have recently setup a mysql cluster, i now
have around 60 tables on it. when i create a new one, it gives me this
error.
ERROR 1005 (HY000
You have to reset the permissions.
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Carlos
On 8/25/2009 7:12 PM, Joe wrote:
We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really
need some help regaining access to. While attempting to
adjust/add remote user access
t User, Host from user;
+++
| User | Host |
++----+
| carlos | localhost |
| root | localhost |
+++
2 rows in set (0.01 sec)
I obviously from above have a user name 'carlos'@'localhost' & when I
try to delete hi
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'@'loc
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
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 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 thin
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='carlo
that right? I'm not sure if COLUMN_NAME is "uid" or "id" or maye
something else, and since I can't pipe it through more or less... :-)
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi Tomasz
There are several solutions for this, one of them, maybe the most
popular, is MySQL proxy, take a look to see if solves your issues.
http://forge.mysql.com/wiki/MySQL_Proxy
Carlos*
*
On 10/25/2009 12:41 PM, Tomasz Chmielewski wrote:
With PostgreSQL, I can use pgpool2[1] tool as a
Yes, you only have to delete the directories.
Carlos
On 11/12/2009 8:16 AM, Miguel Cardenas wrote:
Hello
I noticed that mysql 6 alpha is no longer available so I want to
remove it from my laptop and install the latest 5.x version. I have
just restored my Linux system image so my database is
950C428 | 127.0.0.1 | Y |
|| | localhost | N |
|| | mail | N |
| carlos | *FDCCC9BE5FC366E7D9714988DBC7F111A950C428 | localhost | N |
++---+---+-+
I see
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
t;change the slave to point to the master new position
>start the slave
Hope this helps.
Carlos
On 12/23/2009 2:20 PM, Daevid Vincent wrote:
I got an alert that one of the drives was filling up (3% free). So I
figured out that a large chunk was from /var/log/mysql
r...@pse10:~# find / -type d
Yep, It might not be needed to sync, but its better to double check ;).
Carlos
On 12/23/2009 2:44 PM, Claudio Nanni wrote:
In this case it should not be needed to sync the slave,
Resetting the master basically broke the 'pipe' but events are still
on the new binary logs, it might
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
a
"multivalued attribute" and all those should be avoided. But again, is
up to you.
Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is x is replication and replication2 respectively.
Carlos
On 1/18/2010 1:35 AM, Manasi Save wrote:
Hi Anand,
Please find below my configuration file of both the masters:
ON MASTER 1:
[mysqld]
datadir=/var/lib/mysql/
socket=/var/lib/mysql/mysql.sock
old_passwords=1
log-bin=/usr/local/my
delete statements?
Im trying to figure out whats wrong.
Carlos
On 1/18/2010 11:06 PM, Manasi Save wrote:
Dear Carlos,
Thanks for the response. But I haven't gave any privileges besides
repl_slave priv to user replication and replication2 respectively.
So does that amke any difference rea
Hi !!
You need a left join and then an insert.
Please read: http://dev.mysql.com/doc/refman/5.1/en/join.html or google
for tutorials on left join
And tell me if you have further questions
Carlos
On 1/19/2010 1:00 PM, Intell! Soft wrote:
Hey
Not really quick ;> - But nobody knows
Hi Johny
Do you have the my.cnf configuration file ?? that can simplify things.
Carlos
On 1/20/2010 3:32 AM, Johny Brawo wrote:
Hello!
I got all data files (ibdata1, ib_logfile, etc) recovevered from mine
old Debian 3.1 box (and i dont know MySQL version :( ). I want to get
that DB running
you:
http://datacharmer.blogspot.com/2009/04/test-driving-spider-storage-engine.html
http://datacharmer.blogspot.com/2009/07/sharding-for-masses-spider-storage.html
Carlos
On 1/22/2010 4:47 AM, Krishna Chandra Prajapati wrote:
Hi List,
I am looking opensource tool for mysql sharding. One is mysql-proxy,
Google for "data generator", there are free and commercial solutions
available.
Carlos
On 1/28/2010 5:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses
Absolutely, check for the variable "datadir" on the config file (my.ini
on windows and my.cnf on *nix).
Carlos
On 1/28/2010 9:12 PM, Lucky Wijaya wrote:
Hi all,
I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want
to know if there's a way to
Krishna
I dont have any benchmark but you can take a look on the Cafepress
presentation that includes some data (or ask the authors for deep reference)
http://assets.en.oreilly.com/1/event/2/Horizontal%20Scaling%20with%20HiveDB%20Presentation.pdf
Carlos
On 1/22/2010 11:44 PM, Krishna
) in the config file, and
you may need to change those too.
Carlos
On 1/28/2010 9:25 PM, Lucky Wijaya wrote:
Is that all ? So, if i changed datadir on the config file, whenever i
create databases mysql will store it on selected directory ? How about
the created-before database ?
Btw, I'm
Error 2 is "No such file or directory"
So, probably the file is not in the right path or you need to explicitly
provide the path to the file.
Carlos
On 2/1/2010 5:38 PM, kebede teferi wrote:
Hi, I'm very new to this and I need help.
What I want to do is to execute a
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Have a nice day
Carlos
On 2/2/2010 10:22 AM, ishaq gbola wrote:
Hi Guys,
I have forgotten the root password on mysql database installed on a windows
machine, how can I reset this password. I have tried un-installing and
re
On 2/11/2010 11:47 AM, kebede teferi wrote:
Could any one lead me to a true link where I can download the world.sql sample
database? Thanks.
http://dev.mysql.com/doc/index-other.html
Carlos Proal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I dont know if this can help, but if you are on unix/linux you can call
cat after the dump and easily you can get the output to the stdout
ie:
$ mysqldumptempfile.txt... && cat tempfile.txt
Carlos
On 2/20/2010 9:03 PM, Yang Zhang wrote:
Hi, I'm interested in piping out the
n
I safely remove this account? I don't understand why it's there. I
don't want to break MySQL even though there is no data or databases on
this machine but I would like to keep this as clean as possible.
Thanks for any input.
-Carlos
--
MySQL General Mailing List
For list archives
I am looking for a front end application that will allow me to enter
in all my server / workstation data into a MySQL backend running on
Linux. I have been told that I need to take all 75 servers we have in
our server room and keep a database of the following:
- Make
- Model
- O.S.
- I.P.
- Hostna
I installed MySQL 5 today and started by setting up root passwords for
all three root accounts:
mysql> select User, Password, Host, Create_priv from user;
+--+---+---+-+
| User | Password | Host |
On Thu, Mar 11, 2010 at 11:29 AM, Rolando Edwards
wrote:
> DELETE FROM mysql.user WHERE user='';
> FLUSH PRIVILEGES;
That worked and I thank you however I am wondering why the MySQL guide
was incorrect? Perhaps it's right but I did something wrong. Any
thoughts?
--
MySQL General Mailing List
Fo
I know this is very basic for most on the list but I need some MySQL
help. I am logged into my database and I successfully changed a 'field
type' from INT to VARCHAR. Now I need to modify the actual data I
inserted into those specific fields. I checked the manual and could
not really gather exactly
On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey wrote:
> Please read the tutorial, let us know if you have questions on the
> information in it:
> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
Thank you very much for the link...
I did:
UPDATE sun SET serial = '0123456789' WHERE Model = 'Ul
nd disadvantages, but as a new
DBA is good to get involved in this concepts and comparisons between dbms.
Carlos Proal
On 3/16/2010 12:46 AM, Machiel Richards wrote:
Hi all
Maybe someone can assist me with this one.
A while back I requested some inf
Today I installed MySQL 5.1.45-1 on my production server and it
recommended that I run the following:
/usr/bin/mysql_secure_installation
When I ran this, it simply guided me to do the following:
- set root password
- disable remote login for root
- remove 'anonymous' user accounts
- delete 'test
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman wrote:
> On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens
> wrote:
>>
>> hearing from many admins that MySQL expects and needs there to be
>> three accounts for root. Them being 'localhost', 127.0.0.1, and
>
e.
Does anyone have any clue to work this around? I couldn't find on google.
Hope I did not post on the wrong list.
Thank you,
Carlos Andrade
I couldnt start it, and i did not uninstall it). I
believe you can verify the status by using #aptitude search mysql-server
and checking if its 'i' or 'c' by the left corner of the terminal window and
the package name.
So, after fixing it by dpkg, the socket came back to its pr
ch would work
or if the 'backup' user would require high level privileges.
-Carlos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I downloaded a MySQL script that backs up all my databases
automatically which looks to work amazing. My question is in this
particular script (linked below) there is a section to add a user name
and password for someone who has access to the databases I am
attempting to backup with the script. Now
Hi Mike, you need to query the information_schema schema/database that
contains the database dictionary.
You can read the manual or a beautiful diagram here:
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html
Have a nice day
Carlos Proal
On 5/11/2010 11:06 AM, mos wrote:
At 10:53 AM
I would like to know how I can verify what privileges have been
granted to a specific user on MySQL. I don't remember if my user
'carlos' has specific privileges on 'mydb' database. I am sure I could
simply re-run the following command:
GRANT ALL PRIVILEGES ON mydb
On Thu, May 27, 2010 at 12:26 PM, win.a wrote:
> Maybe phpmyadmin is a choice
No I am only allowed to have MySQL installed. No GUI for DBA. I am
sure there is a way to verify the privileges via CLI, I just can't
locate it on the site / documentation.
--
MySQL General Mailing List
For list archi
Is it normal behavior for MySQL command type ahead not to work unless
you have a database selected? I notice that using the tab 'type ahead'
has no response unless I use a specific database. Is this normal
behavior?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
?
>
>
I dont know the deep details on phpbb, but the account is usually setup
in a config file (there you can change root...).
Also note that mysql extension uses old style passwords and mysqli the
new ones, you can get more info on the manual:
http://dev.mysql.com/doc/refman/5.5/en/o
I am trying to connect to MySQL server [192.168.0.100] from my PC
[10.1.10.222] using MySQL Workbench and when I test the connection, I
get the following error:
"Host 'tuna.iamghost.com' is not allowed to connect to this MySQL server."
Can someone please tell me what I need to do so I can allow r
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar wrote:
> GRANT ALL PRIVILEGES ON *.* TO username@'tuna.iamghost.com' IDENTIFIED BY
> PASSWORD 'password';
>
> *.* ie for all databases , if want on particular DB
>
> GRANT ALL PRIVILEGES ON MyDATABASE.* TO username@'tuna.iamghost.com'
> IDENTIFIED BY
Guys - I am no expert but I don't think this is a DNS or rDNS issue.
All resolution appears to be working fine. When my PC (tuna) attempts
to connect to the MySQL server via MySQL Workbench, it says "Failed to
Connect to MySQL at mysql.iamghost.com:3306 with user root
Host 'tuna.iamghost.com' is no
I have a database called 'gaming' and with in that database there are
several tables and data. I was asked to find a module called 'ako
ldap' and disable it (setting it from 1 to 0). My question is how in
MySQL do I search for a string if I don't even know what table to
search in? I know how to sea
1 - 100 of 304 matches
Mail list logo
