Installation :: Please Configure The 'hostname' Command To Return A Correct Hostname
I installed the latest mysql release on my server today (gentoo linux) and tried to start the mysql server after installation:
-------------------------------
/etc/init.d/mysql start
*you don't appear to have the mysql database installedyet.
*please run /usr/bin/mysql_install_db to have this done.
/usr/bin/mysql_install_db
*Neither host 'hostname' and 'localhost' could not be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
---------------------------------
?? the command hostname is set and returns myhostname. !!
Any ideas what I maybe did wrong or still need to set up??
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
MS SQL Hostname
We have had to change the hostname on an SQL server (Blade and the blade moved chassis so name changed) was blade-0-1-5 and is now blade-0-0-12 It seems i need to run 2 stored procedures which are sp_dropserver 'blade-0-1-5', 'droplogins' go sp_addserver 'blade-0-0-12', 'local' go Assuming this is right I cannot find anyway to run these stored procedures as there seems ot be no interactiove MS SQL unlike mysql.
View Replies !
View Related
Hostname Change And SQL
We have had to change the hostname on an SQL server (Blade and the blade moved chassis so name changed) was blade-0-1-5 and is now blade-0-0-12 It seems i need to run 2 stored procedures which are sp_dropserver 'blade-0-1-5', 'droplogins' go sp_addserver 'blade-0-0-12', 'local' go Assuming this is right I cannot find anyway to run these stored procedures as there seems ot be no interactiove SQL.
View Replies !
View Related
Server Hostname
What do I put in the Server Hostname and also username and password? I just wanted to use this software on my local pc. This form opens when I use the MySql Administrator. I want to import a access database as well.
View Replies !
View Related
Change Hostname
I got the problem that my current mysql config has hostname: localhost. However, I need to change this to 'whatever' so you can logon on certain other programs (services) running on my computer. But I don't know how/where to change my hostname.
View Replies !
View Related
MySql Hostname
I am actually 2 days old to Mysql. Frankly i have no idea what i am doing. I downloaded Mysql 5.1 and also put the Gui and migration tool etc. First of all i tried my hand at Using the Mysql Administrator, I always have the problem with hostname. I have no idea what it is. So i thought i work my hand at the migration tool. i have a access database. i got it working till the point that i had to mention the host name name, username and password. i read the reference manual didn't help much :). I am using windows XP.
View Replies !
View Related
MySQL Connect Hostname
When i am connecting to a mysql database, i usually put localhost as the hostname, but what do i put in the hostname if i have a mysql database located at another .com website and i want to connect to it? I have tried putting in my domain name and it wont connect?
View Replies !
View Related
Hiding Hostname And Password In PHP
I am accessing a mySQL database vis a PHP file. To connect to the database I need to enter the username and password within the PHP code. My concern is that others may be able to view the code and therefore use the username and password to update the database with out authority.
View Replies !
View Related
Cannot Access MySQL With Hostname But Can With Localhost
I'm running Ubuntu Dapper and MySql 5.0.22, which I got from Ubuntu's Synaptic Package Manager. MySQL is running just fine but I cannot connect using my hostname. My hostname is halibut. It is listed as such in my /etc/hosts. If I type hostname, the value halibut returns. If I manually start up MySQL with --log, the logfile is called halibut.log. So as root I invoke mysql and issue grant all on auth.* to 'myuser'@'halibut' identified by 'secret'; create database auth; Then in another window, I issue mysql auth -h halibut -u myuser -p I get prompted for the password which I enter but then I get an error that says Access denied for user 'myuser'@'localhost' (using password: YES). Son of a gun I didn't specify localhost. Now if back in my root window I grant privileges to 'myuser'@'localhost', I can get in. It seems MySQL will not recognize my hostname or rather always interprets it as localhost. If I look at the user table in the mysql database in mysql, and "select host,user,password from user" I see the myuser listed with host=halibut. And now that I added another I also see it with host=localhost. If I drop the entry with localhost, then I cannot log in as before. Does anyone know why I cannot access MySQL using my hostname?
View Replies !
View Related
USER() Function Returns Hostname
Can anyone tell me how to return the username of the currently logged in user without the hostname included. e.g. at the moment:- SELECT USER() AS username -> root@localhost but I really want SELECT (USER) AS username -> root Is there a function to do this, or is there a string search (and chop up) set of functions I'd need to use?
View Replies !
View Related
Hostname In Grant Privileges Statement
I've hunted around on the web for an answer to this, but haven't been able to find anything to clarify my understanding of hostname in the MySQL GRANT statement. When granting privileges on a database for a particular user in mysql, i'm a bit confused what to specify for the hostname. What is the difference between: grant select on mydb.* to someuser@"localhost" identified by "password"; an grant select on mydb.* to someuser@"%" identified by "password"; If i specify "localhost" as the hostname, i assume it means that connection to the database is only allowed from the local server machine... but I want global public visitors to be able to view my website and therefore connec to the database.. so should I be using "%" instead? Is my understanding of hostname correct?
View Replies !
View Related
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
View Replies !
View Related
Configure Existing MySql Installation
I'm trying to ascertain how to configure MySql to support secure connections without having to rebuild the source code w/ the --with-vio and --with-openssl options. Since the opensource binary provided has a default of no for have_openssl, is there a way I can modify an existing installation to support secure connections?
View Replies !
View Related
Correct Import Command
i am having trouble importing a database into MySql 5.0 i have created a database and have the .sql file ready but when i type in my command i never get the next step. database name = bdatabank command I am trying to use from the mysql> prompt is below: -u username -p -s bdatabank < BDB-sql-2007-11-16.sql --after typing this and pressing enter i should be getting the 'Enter Passwor' prompt. but all it get is another blank line with a prompt of -> am i miss typing something?
View Replies !
View Related
Installation (groupadd And Useradd) Command Not Found
I've installed Suse 9.2 with KDE desktop. I am trying to install MySQL, and downloaded version 5.0. I tried to follow the installation text file instruction, but I can't even perform the first two commands: shell> groupadd mysql shell> useradd -g mysql mysql (For both I get "command not found"). Any clue what I should do, or a good reference to easily do it?
View Replies !
View Related
Min Returns Correct Min Value, But Not Correct Row
select min(time_to_sec(bests.time)) as aggregate_value, * from bests left join events on bests.event_id = events.id where fid = 13463 group by bests.event_id if i query that i get the correct min value as "aggregate_value" but everything else is for a random row (presumably the first row as ordered by id asc). is this the correct functionality of mysql?
View Replies !
View Related
Configure
"mysqli" is not getting enabled with php 5.0.3 after configure.. './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-mysql=/usr/local/lib' '--with-mysqli=shared,/usr/bin/mysql_config' '--with-mysql-sock=/tmp/mysql.sock' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-ftp' '--with-zlib' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--enable-xslt' '--with-xslt-sablot' '--with-kerberos' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--enable-magic-quotes' '--enable-discard-path' '--enable-sockets' Any idea how to configure it with php 5.0.3
View Replies !
View Related
Configure Wait_timeout
I am using MYSQL version 5.0 (5.0.46). I intend to configure wait_timeout variable by updating the my.ini file(WINDOWS XP). But the value updated in this file is not getting reflected when checked in MYSQL command prompt. I did restart the MySQL Service after updating the .ini file. 1. Path of my.ini file : C:Program FilesMySQLMySQL Server 5.0 2. Contents of my.ini file Expand|Select|Wrap|Line Numbers
View Replies !
View Related
Configure MySQL
In this matter i've searched in google but don't find the one which is related to my problem. there is no internet connection in that computer in which i've installed MySQL. In the last step of configuration a message appear "port 3306 is not avilable" according to the message i try to add port but also it's not working? Is there any solution.
View Replies !
View Related
PHP Configure Error
I am doing a fresh install of MySQL, Apache2, and PHP5 on fedora2 core. I am installing from tar.gz files, MySQL and Apache installed and tested fine, then I stopped HTTPD. When I configure PHP I get the following config error at the end of configure' : configure: error: Cannot find MySQL header files under yes. I'm using the basic configuration string from the installation page: ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql Then the make error is: make: *** No targets specified and no makefile found. Stop.
View Replies !
View Related
Configure And Connect Mysql
I am in process of learning and equip myself with Java technology.The problem encountered is to connect and configure mysql with jdbc in windows environment. How to set the driver manager?where to set it?I am now quite blur and confused..I try to type 'mysql' MS DOS but there is an error stated "can't connect My Sql in localhost".
View Replies !
View Related
Configure Old Hardware For A Dedicated
recently got hold of some old Sun equipment, and I thought it would be good to set it up as a dedicated MySQL database server so I can learn more about MySQL. The hardware I have is: Sun Ultra 2 Enterprise 2x300MHz SPARC 64-Bit CPU's 768Mb RAM Internal 2x4Gb Hard Disks External 12x9Gb Hard Disks Solaris 10 I am probably going to be using it for a blog software, photo-gallery software and general "messing around" while learning SQL and MySQL :), because of this the hardware should be more than enough - but I would still like to get the best out of this hardware. Can anyone give me opinions on how to set this up? Due to the age of the system I am going to have to tune it to its maximum so I can get the best out of it. Some of the things I have been wondering are, should I run MySQL as a 64Bit binary? How would it be best to configure the hard disks?
View Replies !
View Related
Configure MySQL ODBC Driver
I'm working on a MFC application and I need to be able to prompt the window "MySQL ODBC 3.51 Driver - DSN Configuration" for the user to configure a dsn connection... This is like selecting the "ODBC Data Source Administrator", selecting the File DSN tab, clicking one of the dsn links and then pressing configure... Is there a way to prompt this precise window programmatically?
View Replies !
View Related
Using Terminal To Configure MySQL Database On Mac OS
I am in the process of installing and configuring MySQL and PHP internally on my Macintosh so that I can go through the tutorials in the book "Build Your Own Database Driven website using PHP & MySQL." I am on the step where I have to change my root password. I'm pretty sure that I've done everything up to this point correctly. I just keep getting the same error message when I try to connect to my MySQL database using this command: mysql -u root mysql Upon pressing enter, I get the following error message: -bash: mysql: command not found
View Replies !
View Related
Configure Mysql To Compensate For Bad Structure/queries
It seems like $formerprogrammer knew just enough about php/mysql to write a working product on a REALLY bad design. Not surprisingly our company/client decided to jump write into the terrible design and there's a lot of important data tied up in a terrible structure. To give an idea, we've got roughly 4 tables of "equipment' each with between 100,000 and 500,000 records that are between 10 and 15 fields long. Certain fields are of variable length (model number from different suppliers) and need to be searched on with wildcards. My conundrum is this, the existing database design has to stay, there are roughly 80,000 lines of just as poorly written php code that somehow manage to execute on top of this structure and need to continue doing that until I redesign the system. However our main issue with this tool is speed, a cacophony of sql queries need to run to make things work, thus bogging down mysql. I'm not too familiar with configuring mysql, and I've done my best to make this run efficiently by increasing key_buffer_size and innodb_buffer_pool_size however it seems no matter how large I set these (currently both at 256M) I still get hundreds of slow queries (over 10s) per day. Obviously the end goal is to redesign properly, but until then is there anything that can be done in my.cnf to handle poorly written queries running on a lot of data?
View Replies !
View Related
Configure InnoDB Case Insensitive With UTF8
Configure innoDB case insensitive with UTF8 Is there some way I can select from an innoDB table, with char-set UTF8, in a case insensitive mode? Table: ----------------------- country | city ----------------------- SE | Stockholm US | New york ... This query works: SELECT country FROM cities WHERE cityName = 'Stockholm' This query does NOT work: SELECT country FROM cities WHERE cityName = 'stockholm' What is the problem? InnoDB, UTF8 or me?
View Replies !
View Related
Correct Syntax
I have a database of addresses where I am trying to remove rows that have a particular duplicate field. For example, say there are 15 rows in the table sales_info that have the value 'Mr. Smith' in the contact_name column. I've tried using the following command but received an error (1064 check you manual for the right syntax): UPDATE sales_info DELETE* FROM sales_info WHERE contact_name IS NOT UNIQUE; Can anybody help me with the right syntax to use?
View Replies !
View Related
Correct Results From Db
I have a column of type text, in this column I am adding in numbers that relate to another column in the table. For example the column in question could end up having the following data in it: 1, 2, 6, 9, etc The problem I am having is if I want to return all the results that relate to lets say the number 1 and if the column in question has more numbers in it than the number 1, I don't get anything returned. Is this an error with my ASP script or the way the data is stored in the dababase. Do I need to change the data type,
View Replies !
View Related
Getting The Correct Row With Unicode
I'm having some trouble getting the correct column from a unicode table: DATABASE: Server version: 4.1.15 MySQL charset: UTF-8 Unicode (utf8) TABLE: CREATE TABLE `domain` ( `id` mediumint(7) unsigned NOT NULL auto_increment, `name` varchar(70) character set utf8 NOT NULL default '', ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `domain` (`id`, `name`) VALUES (506418, 'vad'), (522014, 'våd'); QUERY: SELECT * FROM `domain` WHERE `name` LIKE 'våd' RESULTS: id name 506418 vad 522014 våd QUESTION: How do I structure the select statement to correct get the row (ID 522014) that matches the unicode ...
View Replies !
View Related
Which Design Would Be Correct?
I have registered users, and these users can belong to a group. I'm trying to decide whether or not i should keep this group_id in the users table, or to create a cross referencing table and just keep the user_id and group_id in there. the cross reference table will allow for users to be associated with more than one group. and just keeping the group_id in my users table will allow me to avoid a few joins in some queries but only allow one user per group... any opinions on this matter? after typing this i feel as though creating the referencing table would be the better idea.. but i still would love to hear other opinions.
View Replies !
View Related
Which One Ini File Is The Correct One ?
I have install mysql in my windows machine.The confusion part here is that I find there 7 different ini files. The files are my.ini,my-huge.ini,my-innodb-heavy-4G.ini,my-large.ini,my-medium.ini,my-small.ini and my-template.ini. So which one is being used as the configuration files. I assume it is the my.ini one right ? So why is there so many other ini files? My another question is that in my.ini I dont find the option for the bin-log settings but ? Because I want to the option of binary log to be enable to allow me to trace back if there is any mistake ?
View Replies !
View Related
|
TRACKER
