Accessing Mysql After Fresh Installation
I have recently installes mysql -4.0.0.1 on my redhat 7.1 machine . After
installing when enter into mysql it gives me message " Access denied for
user root@local host .......using password yes"
i have tried all the options like
#mysql -u root -h localhost
#mysql -u root -h localhost -p
#mysql -u root -h localhost -p mysql
#mysql -u root -h localhost test -p
#mysql -u root -h localhost test
#mysql -u root
#mysql -u root mysql
but none of the option is working at all.
Please any idea how i can change the root password or enter the mysql after
fresh installation.
View Complete Forum Thread with Replies
Related Forum Messages:
Fresh Installation Versus Copying /usr/local/mysql
I've recently taken over the management of a production mysql environment that was previously managed by Unix sysadmins. It currently runs mysql 4.0.18 on both Solaris and Linux machines. We've QA'd mysql 5.0.51a and are pushing to upgrade in production. Under the previous management, the sysadmins would just tar up /usr/local/mysql and copy it to another machine when they built a new mysql server. Is this a valid way to perform an upgrade or an installation? I mean installing mysql 5.0.51a on one server and just copying the base directory to other servers. My mind and my gut say it would be better to do a fresh installation on each server, but I anticipate some resistance from the sysadmins who still maintain a lot of control over the servers. If copying /usr/local/mysql to another machine is valid.
View Replies !
How Do I Remove MySQL So I Can Start Fresh?
I installed MySQL ver 4.0.20d on a Windows XP Professional PC. I created a user and database that I would like to delete, and at this point I would just like to uninstall MySQL and do a fresh installation. I have deleted MySQL by going to Start > Settings > Control Panel > Add or Remove Programs. However, when I reinstall MySQL, the previous user and database are restored, too. How does one do a complete removal of MySQL so that it can be reinstalled as though it was never on the PC before?
View Replies !
Starting Fresh With Mysql >> Dadabik
I have an Excel spreadsheet which has been my source document for the past several years for a collection I own. It has about 2000 entries (records) and each record has ~20 fields. Photographs of each item in the database are an integral part of this. What I'd like to do is move all of this knowledge onto the web in database fashion and provide a means to allow users to search the database. I found DaDaBIK which seems to be perfect for the show and tell phase of my project, but I need to create the database properly first. I can make a mysql database with my hosting account, but I don't know where to start. I know databases can be tricky; at least what I know of Access is tricky, so I want to do this right. I'm looking for help, maybe a simple tutorial, that will guide me through the process of transforming my Excel data and photos into a mysql database online. I have googled for this, but there are so many articles, and it is all over my head anyway.
View Replies !
Fresh Install, First Time Login
I've just installed MySQL 5.2 and MySQL Administrator 1.2.9. Sadly, I cannot establish my initial connection to the MySQL instance, nor can I find any documentation on such. Idiot lesson, please: Do I need to start with a Stored Connection? Is Server Host of '127.0.0.1' correct? Port of '3306'? Username 'root'? What about password?
View Replies !
Fresh Install Won't Allow Root Access
I just installed version 4.1.10a on Windows XP. I am able to start the instance with the command: mysqld --defaults-file="C:Program FilesMySQLMySQL Server 4.1my.ini" When I try to shut down, I get the following error: mysqladmin -u root shutdown mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' As far as I can recall, I didn't specify a root password during the installation process. What should I do to reset the root password?
View Replies !
Error 1045 After Fresh Install
I've just installed MySQL on my home machine. I'm absolutely new to MySQL and have encountered the following error after the command mysql -u root -p: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) During installation I never set a password. I've input 'admin', 'root' and other guesses in as the password - the error is always the same. If I provide a carriage return without entering anything, the error changes slightly: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I've seen this question posted elsewhere but have been hard-pressed to understand answers provided. Can someone provide an absolute newb with some guidance?
View Replies !
Accessing Dev.mysql.com
I'm trying to download MySQL4.1 from the MySQL site and when I try and go to the download section on the site it either fails or, if it loads, the "pick a mirror site" links always fail. By "fail" I mean that it doesn't manage to retrieve the requested page, either sticking on "waiting for dev.mysql.com" or "connecting to dev.mysql.com" in the status line of the browser, eventually giving up with an "operation timed out" error message. Is anyone else having this problem or is it just me? - this has been ongoing for the past couple of days now. Incidentally, I need a version of MySQL that can handle subqueries yet I'm still using glibc-2.2.5-40 and Redhat 7.3 (upgrading simply isn't an option right now) - can anyone suggest a stable sub-version of 4.1 that fits this criteria?
View Replies !
Accessing MySQL DB From Another Domain
what is the best way to access data in a MySQL database on one domain from a PHP script on another. We have a secure (SSL) server on one domain which will be used for secure credit card transactions. We would like to be able to extract insecure contact information from MySQL database on another domain in another hosting environment.
View Replies !
Accessing MySql On Yahoo
I have never used MySql before.I program in C# and Visual FoxPro against MS SQL on a corporate network. I have a Yahoo web page, and I'm going to use their MySQL DB. I want to run queries, Inserts, Updates and Deletes. I have no idea how to connect to MySql on Yahoo from a client like C# or VFP.
View Replies !
Accessing MySQL Database.
I have recently installed MySQL 5.0.27 / PHP 5.2.0 / Apache 2.2.3 on an XP os. I created an empty database via the MySQL command line which is visible when I type SHOW DATABASES at the mysql prompt. I have changed my root password which works OK. I set up the password to the empty db by: GRANT ALL ON database name.* TO username@localhost IDENTIFIED BY 'password' To access the db, when I type : mysql -D dbname -u username -p I do not get a prompt to enter the password.
View Replies !
Accessing Mysql From Another Host
New install of mysql on Solaris 10 x86. I cannot connect from any other host, lots of traffic on google with people with the same error. Talk of the grant command fixing this, but no details. So simple question. What "exactly" do I type to allow connections to port 3306 from another host to avoid messages such as ERROR 1130 (00000): Host 'am-ms-t.foo.baa' is not allowed to connect to this MySQL server
View Replies !
Accessing MySQL Data
This morning when I tried to access my MySQL installation through MySQL Query Browser, all schemas have a message stating "Fecthing Data..." when I expand the schema. If I access MySQL through the command line, I get the following message when I execute a "use" command: "Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A" If I execute mysql using "-A", then it appears I can access the data, but it's very slow. Has anyone experienced this and if so, do you know how to resolve it?
View Replies !
Accessing Mysql Server On LAN
I have a problem accessing mysql server on my LAN: i can access it locally but not from other machine. The error is: Lost connection to mysql server during query. I've disabled the firewall but it's still not working. What i don't know is if i set the users correctly...
View Replies !
Accessing A Mysql DB Remotely
I am building a kiosk which uses a lockdown browser. The browser uses a php page to access a MySQL DB on a web server. It will not allow me to connect to the DB because I am using the following connection string: mysql_connect("localhost","*****","*****"); mysql_select_db("******") or die ('I cannot connect to the database because: ' . mysql_error()); I know that the problem here is that I'm trying to connect to 'localhost' when the actual DB resides elsewhere. The question I'm asking is how to find out how to connect to my DB. Is it just mysql.mydomain.com instead of localhost or what?
View Replies !
Error 1130 When Accessing MySQL From Another IP??
I am trying to run the MySQL DB on a Linux machine that is part of a home LAN (IP=192.168.0.3), while trying to access it from another WinXP machine (IP=192.168.0.5). I keep getting the following error: MySQL Error Number 1130 #HY000Host '192.168.0.5' is not allowed to this MySQL server Ping works fine. On searching the internet, I find reference to "allow list" hidden somewhere in the guts of MySQL. Can anyone provide me hints on how to add to this list?
View Replies !
Accessing Mysql Database From Php File
I can access mysql in dos with the command of c:mysqlinmysql -u root mysql but when i write the command of mysql_connect ("localhost", "username", "password") i don't know what my username or password is. I have installed Apache to run the mysql database and php on my computer although I don't know where to find out the username and password so if someone could help that would be great.
View Replies !
Accessing Mysql From Command Prompt
The path to my mysql installation is "C:Program Filesxamppmysqlin". I want to run myisamchk - to do this I think I have to access it via the command prompt. A stupid question - I kmow - but how do I get to the directory in a DOS window??
View Replies !
Accessing Mysql/bin Directory Problem
This may be very basic question, that I hope some of you can answer very quickly for me. I'm running mysql 4.1 on windows xp just to learn the database, and I'm in a need to run .exe in the bin directory. The problem I'm having is accessing this directory. The path is C:/Program Files/Mysql/Mysql server 4.1/bin but when I get to C:/cd "Program Files/..." I get an error message saying (parameter format not correct - "program) i have tried several things, as well as following a user guide for changing directories that states that if the folder name has spaces use " to access that subfolder...maybe there is a simple tip ...
View Replies !
Accessing Remote MySQL Database
Is it possible to access remote MySQL databases? I manage several sites and I will soon be building a tool that can track all of them, and it would be really convenient if I could somehow access all of the databases from one remote site.
View Replies !
Accessing MySQL BLOB Columns Using Visual C#
I am trying to write an image file to a remote MySQL Database. The following code show the section I try to save the ImageArragy into the MySQL BLOB column. The error that I am getting is : Can someone tell me where I am going wrong and how I can fix this problem?
View Replies !
Accessing Data On An SQL-Server By Using MySQL-Select
is it possible to access data located in a SQL-Server-Database by using a MySQL SELECT-Statement? I know that on an I can use a qurey like the following SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:Financeaccount.xls";User ID=Admin;Password=;Extended properties=Excel 5.0') on an MS-SQL-Server and search for something similar in MySQL.
View Replies !
Accessing A Mysql Database On A Remote Server
i would like to know how to connect to a remote mysql server which is on linux from a windows system. I gave the command: mysql -u root -p redhat -h 192.168.1.132, where the ip is the ip of the linux server. But i got the error message stating that :- Host 192.168.1.114(which is my system ip) is not allowed to connect to this MySQL server.Sreejith
View Replies !
Accessing MySql Thru Coldfusion - Password Problem
I have downloaded MySql 5.0 for Windows (XP) and MySqlCC so I can interact with it. When I installed MySQl I created a username and password which I can see in "my ini" file. I don't remember creating any passwords through mysqlcc. I am building a database driven website using "macromedia studio MX" and am experiencing problems accessing my Mysql database through that software - I keep getting asked for a login ID and password, and for the life of me, have no idea what they are. 1. When I originally added my database as a 'data source' in Cold Fusion (MX 6.1 administrator) it would not let me create a password. I kept getting error messages like "The root cause was that: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'martin'@'localhost' (Using password: YES)" etc etc etc variations on that theme. (adding the database without a password wasn't a problem) 2. Now I am trying to create a dynamic page in Dreamweaver (using Coldfusion) to display my data – there is a 6 point process in the ‘server behaviors’ tab and I’m up to the last one “press the (+) plus button and choose ‘Recordset (Query). WHEN I SELECT MY DATABASE AS A DATA SOURCE IT ASKS ME FOR A "LOGIN ID" AND "PASSWORD." I've tried all the passwords I can think of that I used and nothing works, the error message I get is: "-1:Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'wine like '%' at line 1. this is then followed by about 27 lines of commands like "at org.gjt.mm.mysql..".bladedblahdeblah " (I am creating a database of wine tasting notes)
View Replies !
Accessing Mysql On Win2003 Server From A Station
I have installed Mysql on a Win2003 server and it is running as a service. I created a database and it works ok on the server logged on as root. I then tried to access the database from a station on the network using PHP code and I get the error - Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in G:InetpubWWWrootIntranetookingacc.php on line 10. Do I need Mysql Client on the station or does it run on the Server by default?
View Replies !
Error Accessing MS Access Table Linked To MySQL
I create the linked tables without any problems, clicking on "save password" before selecting the desired tables. I can then access both tables fine from within the Access GUI. The problem starts when I then try to access this data from my ASP.NET web application - classic ASP works fine but .NET gives me... ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN' failed. From then on, the Access database remains locked (.LDB file in the same directory) and I get a similar error when I run my ASP page, which previously worked. Code:
View Replies !
Mysql 5 /msi Installation
i had mysql 5 alpha installed and npow i uninstalled due i downloaed the latest v5 .msi. Although i uninstalled the previous mysql before installing the current one, the latter wont be able to start when try to install itslef as a windows service. I have disables from administrative tools-services the previosu mysql set it to disable so now i guess the old one its not runnigns as a service but the new one wont start why?
View Replies !
New Mysql Installation
I just installed MySQL and the appropriate ODBC driver on IIS 5, and can't make it work. The db server itself is running as a service just fine. Here's the error I get when trying to connect from a PHP script: Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) I get a similar error trying to connect from a command line. I feel sure I must have skipped some necessary step in setting this stuff up.
View Replies !
Installation Of MYSQL On OS X
I installed MYSQL on my MAc -OS X 10.3.9. When I try and connect I get the following error: Welcome to Darwin! /usr/local/mysql-standard-4.1.12-apple-darwin7.9.0-powerpc/bin/mysql; exit Mist:~ jbrousseau$ /usr/local/mysql-standard-4.1.12-apple-darwin7.9.0-powerpc/bin/mysql; exit ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) logout [Process completed]
View Replies !
Mysql Db Installation
I installed mysql server and i dont understand what i have to do from this point in order to have mysql database. Do i need to run script for create database Code:
View Replies !
MYSql 5 Installation
Downloaded MySql 5 and installed OK. However when I try to set up a MySql instance, using all the defaults and InnoDB tables, the service will not start. I checked Admin->Services and the MYSQL service is there and is set to start automatically but is marked stopped. When I try to start it I get error 1067.
View Replies !
PHP-BB And MYSQL? Installation?
I've got my own web server in my office which i use to run my business web site from. It already has Perl, and I installed PHP last night. I installed it because i want to make forums for my site. I'm pretty new to php, but i'm a fast learner, and decided to have a go. I also installed PHP-BB to make my forums with. The problem is, it's asking me for a database something? Now i don't know what on earth to do from here. I've tried selected all of them to see if they'd work, but they didn't. I think i need to install some kind of database thing to my server so i can set my forums up. has anyone any suggestions, and if they have, how do i go about it?
View Replies !
Help With MySQL Installation
I was wondering if any one out there could help me. I'm new at MySQL and just beginning with Kevin Yank's book. I have downloaded and installed MySQL as instructed, everything seems to run perfect until I change the password for the root user. From there on when I try to run Mysqladmin I'm requested my new password but when I enter it I get the following error message. MySQLAdmin: connect to server at local host failed. Error: 'Host 'localhost' is not allowed to conect to this MySQL server' I also tried to open mysql command line and I get this error message: error 1130 (HY000) Host 'localhost' is not allowed to connect to this MySQL server. What am I doing wrong?
View Replies !
Installation And Config Of MYSQL
Installed Mysql in Redhat 9.0 workstation. I have installed MYSQL,Appache,PHP. PHP,Appache installation is fine and intergration is also working fine. I have installed and configured MYSQL Problem : I cannot log into MYSQL database either from root or user.(local host) The error is 2002: unable to connect to local host thru socket "varlibmysoc" but cannot locate the mysql.sock in /tmp And the service is sqldb is also not working and cannot locate in services.
View Replies !
MySQL Localize Installation
In MySQL features, it is mentioned that it supports localization/internationalization. I tried MySQL setup installation but doesn't prompt me for language selection for setup. Does mysql supports installation in local languages. I want mysql setup instructions/messages (GUI) to be displayed in local languages. Can "mysql Administrator" setup also be configured in different languages?
View Replies !
MySql Installation On Solaris10
I installed Solaris 10 on a Pentium machine. Then i came to know that MySql comes bundled with Solaris 10. So i installed MySql which came with the Solaris 10. Then i checked the version of the MySql i installed using mysqlcheck -V and the version shown was 4.0.24. I wanted the latest version of MySql (5.0) to be installed in the Pentium machine. So i downloaded the mysql-max-5.0.21-solaris10-i386.pkg.gz and installed it as before and started the MySql server. Again i checked the version and it is still 4.0.24 instead of showing 5.0.21. I dont know what went wrong. The reason i wanted the latest version of MySql is to use the MySql cluster.
View Replies !
Installation Of Mysql 4.0.14 On Windows Xp
I am new to mysql server and trying to install the mysql server on my windows xp home edition. I have downloaded 4.0.14 zip file on my computer. I can unzip the file and it generates 10-15 files. When I do double click on the setup.exe it loads for 5 seconds and then stops. No window is displayed. No error message is generated. I thought may be I should try some other version. I downloaded older version 4.0.13 and same thing here. I downloaded 3.23.57 and same thing here. I am logged in as administrator. I can install other softwares without any problem. Can you please suggest any thing I should try to install the mysql server.
View Replies !
MySQL Installation Problem
We are having some trouble installing a MySQL database onto one of our servers and would appreciate some assistance, details are below. Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1. We have downloaded the source files from your website and have had a go at trying to install the software following the instructions on the user manual. We get to the point of configure and we get the following output: root@stats1 > ./configure --prefix=/usr/local/mysql NOTE: This is a MySQL binary distribution. It's ready to run, you don't need to configure it! To help you a bit, I am now going to create the needed MySQL databases and start the MySQL server for you. If you run into any trouble, please consult the MySQL manual, that you can find in the Docs directory. Installing all prepared tables 030818 10:39:06 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system Code:
View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
View Replies !
Mysql Installation Failed
Anyone can help me and I would appreciated. I install mysql on Fedora linux from binary source which i download version mysql 5.0.22 tar.gz starting with this cmmand gave me the error: shell> bin/mysql_install_db --user=mysql [root@localhost mysql]# bin/mysql_install_db --user=mysql Didn't find /mysql/bin/mysqld You should do a 'make install' before executing this script I did make install and I tried manay time still don't work, any idea and I don't get the right binary source code or any other source code that you can recommanded
View Replies !
MySQL Installation Documentation
EVERY SINGLE WINDOWS XP user who ever installs MySQL has to open port 3306 in the firewall, and make an exception for the binary mysql.exe to allow connections to be made to it. Yet this not mentioned in the installation process. For another example, the documentation sometimes asks you to enter commands like "mysqladmin version" that actually have to be entered as "mysqladmin -u root -p version". For another example, the "detailed configuration" sometimes fails at the last step, and the only solution is to uninstall MySQL, re-install, then run the configuration wizard later. This bug is not documented. It is then too late to move the InnoDB tables to where you want them, though; the documented way to move the InnoDB tables doesn't work. For another example, it is almost impossible to get MySQL to work with localhost pipe connections on Windows. Supposedly you could to this by starting the service with the "--enable-named-pipe" parameter. But Windows XP has a horrible bug, in that parameters given to services entered in the "Start parameters" window of a service are not saved and not used. Most people give up and use TCP/IP, thus slowing the server down and creating a security hole. This is related to the error "Cannot connect to mySQL server on localhost <10061>", which almost everyone who has ever installed MySQL on Windows gets. Put a friggin' section in the installation documentation about it, already.
View Replies !
Installation Of MySQL On MacOS
I had installed mysql version for MACOS but whenever i am trying to create a database using terminal(command prompt) window it says command not found. Can any one tell me that this problem is related to installation of sql on mac or why i am getting this problem?
View Replies !
|
TRACKER
