On Thu, Nov 4, 2010 at 5:13 AM, Christoph Boget
christoph.bo...@gmail.com wrote:
I think
it might be time to start seriously looking at Postgres...
Even though all the info you provided is extremely
exaggerated...switching all my databases to PostgreSQL has been the
best thing I've done in
I have an existing table with a few columns I created a few months
ago. Sadly I left out the column I would like to use for my Primary
Key and wanted to know what is the best way to add a column to an
existing table but also I want the column to appear first before any
other columns since it's the
I am new to MySQL coming from PostgreSQL noticed a really annoying
issue. When I select a database, and try to auto complete in MySQL, it
doesn't capitalize the MySQL statements.
It's irritating to me to only be able to auto complete statements like
'SELECT', 'ALTER', 'INSERT' only if I hold
On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent dae...@daevid.com wrote:
Get this tool: http://sqlyog.com/ it rocks.
There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
I can't use any graphical or 3rd party add-on's. I was hoping MySQL
had this native / built in. I guess
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
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
On Tue, Jul 13, 2010 at 3:25 PM, Prabhat Kumar aim.prab...@gmail.com 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'
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
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 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.* TO 'carlos'@'localhost'
-
On Thu, May 27, 2010 at 12:26 PM, win.a win@gmail.com 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
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.
I downloaded a MySQL backup script today since I have 3 or 4
relatively small databases. The script can be found here:
http://sourceforge.net/projects/automysqlbackup/
Now I was wondering if I can create a local database user
'backup'@'localhost' grant him a level of permissions needed to
On Wed, Mar 31, 2010 at 3:07 AM, Johan De Meersman vegiv...@tuxera.be wrote:
On Wed, Mar 31, 2010 at 12:25 AM, Carlos Mennens carlosw...@gmail.com
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
hostname
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
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
redwa...@logicworks.net 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
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
On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey gto...@ffn.com 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
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.
-
20 matches
Mail list logo