Reinstalling Mysql On Local Machine
I had mysql install from the XAMPP bundle, but was having issues with that setup, so I uninstalled and deleted all related directories. Now, when I atmysqlt to install mysql from their distributions from mysql.com, it will not let me assign a password to the root account. The install errors out when trying to apply the security settings.
The error number is 1045, saying access is denied for the root@localhost user.
View Complete Forum Thread with Replies
Related Forum Messages:
Importing MySQL Database To Local Machine
I have exported a MySQL Database from a remote server using PHPMYADMIN, saved on my local XP machine as an sql file to insert (with name _DB_.sql) but am not sure how to get this to run on my local XP machine which is running MySQL locally; When I view the file on Notepad it appears to be executable in some way as it includes CREATE command etc. I tried the following from MySQL command line SOURCE C:/Program files/MySQL/_DB_sql but can't see any evidence of the database having been created on my local machine.
View Replies !
How To Insert Machine (local) Time In Mysql
This is a problem I encountered in mysql: how do I insert local (machine) time? To do this in MS Access, just put now(). I tried this in mysql, it does not work. see graph(the red chinese characters means the same thing as above.)
View Replies !
Can't Connect To MySQL Server On Local Machine
am following along in Head First's PHP & MySQL book, at chapter 2. I've downloaded PHP, MySQL, and Apache. A couple basic scripts have worked fine, so I know PHP is working. I can create a table and a database in MySQL throught the command line window, so that seems good. But I'm trying to execute an INSERT function on the example table that the book had me make, using a script, and I'm getting "Error connecting to the MySQL server" which is the or die error message I used for failure to connect. In setting up MySQL, I was prompted for a password but not a username. So I'm trying to leave the username data blank in the mysqli_connect function. I wonder if this is my problem? I've looked through my.ini but to my untrained eye it's all Greek and I can't spot usernames or passwords there, or in any of the other .ini files in the MySQL folder. If I need a password, can anyone tell me how to find out what it is? Here's how I wrote the connect function (username is blank, surrounded by single quotes): $dbc = mysqli_connect('localhost', '', 'password_here', 'databasename_here') or die('Error connecting to MySQL database.');
View Replies !
How To 'Publish' Mysql Db From Local Machine To Live Web Site?
- We have just created our first simple MySQL database on a local XP Pro machine. - Just a simple database named MyDb with a single table named Contacts. - MS Access created a single .mdb file we would 'publish' or ftp to the server. - MySQL seems to create... ... a folder for the database named MyDb ... a file for the table named Contacts.FRM ... and another file named db.opt My questions: 1 - Are the two files above what we should put up on the live web site? 2 - Or stated more generally... ..... once you develop a mysql database locally ..... how do you then put it up on the live web site? ..... which files are the actual database? ..... what are the file extensions on a mysql data base?
View Replies !
Copy/move Mysql Data From Local Machine To Remote Server Database
I have an website that is host on web server and here have a database that have only one table name is "user" Table fields are: name Id no email phone And I am using same site in my local machine. I always use my local machine for data entry and everyday end of the day I want to transfer data by clicking one button from my local machine database table to my remote server website database table. How can I transfer data from my local machine database table to my remote server website database table.
View Replies !
Connecting On A Local Machine
I have recently installed Mysql on my local machine. I can access Mysql through the Mysql Command line client. But I can't connect through mysql_connect.php script. I have always used mysql through our hosting company with no problem. This is the first time I have installed it on my machine. When running the script I recieve the following error Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061
View Replies !
Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the same environment on the laptop, retrieving trivial amounts of data (5 rows) from a table is taking 6 seconds. Updates the same. IN otherwords any table access takes 5 or six seconds. (Table only has about twenty rows in it). I can connect to the database on the laptop from the desktop (i.e - application runs on desktop, retrieves data from laptop - works fine, not noticeably slower than local on desktop. If I connect the other way - application on laptop, database on desktop, it runs just as slowly as locally. The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:
View Replies !
Database From A Localhost (local Machine) To A Server
i've setup a web page using MySQL5.0, Apache and Php.. i've finish the webpage but im facing a probs in uploading the database to the server.. i dont even know where the database are stored in my local machine and how will i transfer to the server. My hosting have My SQL 4.1.22-standard and phpmyadmin but to SSH acces..
View Replies !
Exporting From PhpMyAdmin On Server To MAMP On Local Machine
I thought that transferring the database from the server to my hard drive and working with it using MAMP would be fairly simple, but I am lost on the options and get: Error SQL query: -- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jan 22, 2008 at 11:02 PM -- Server version: 5.0.27 -- PHP Version: 5.2.1 -- -- Database: `trumpet` -- -- -------------------------------------------------------- -- -- Table structure for table `articles` -- CREATE TABLE `articles` ( ... etc. ... ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =15; MySQL said: #1046 - No database selected Could someone give me some guidance on how to get the database to my hard drive so I can develop locally rather than via the internet?
View Replies !
Dumping My Live Database And Then Putting It On My Local Machine Problem..
I have tried copying the dumped sql code in mysql query browser once dumped from live and it doesn't execute it, i have to extract it line by line and that would take forever to do this all, is there an easier way to do this or can someone run me through the basics on how to achieve this? i have on my live site: 4.0.25 (patched) and on my desktop computer : 5.0 Would this be part of the reason? i don't know..
View Replies !
Reinstalling Mysql
I had mysql install from the XAMPP bundle, but was having issues with that setup, so I uninstalled and deleted all related directories. Now, when I attempt to install mysql from their distributions from mysql.com, it will not let me assign a password to the root account. The install errors out when trying to apply the security settings. The error number is 1045, saying access is denied for the root@localhost user. Also, when I attempt to use the mysql command line client, when I enter the password, the command screen just disappears.
View Replies !
Uninstalling / Reinstalling MySQL
I want to completely uninstall and reinstall MySQL. However, when I unistall MySQL in the standard way, some data remains and when I re-install it retains some data from previous sessions, passwords etc and PHP cannot connect to the newly installed version. How can I fully remove and re-install MySQL?
View Replies !
Wiping MySQL And Reinstalling..
I'm trying to get rid of the mysql-standard-5.0.27-osx10.3-powerpc folder and the mysql-standard-5.0.27-osx10.4-powerpc folder in /usr/local/ but it is telling me the files are in use.. how do i fix this? I feel like I messed up somewhere along the way because I've been jumping back and forth between PHP and RoR.. I want to just start over because I feel like some things may have gotten mixed up. I wish there was an Apple +Z for the last 2 days...
View Replies !
Uninstalling Then Reinstalling
I am having what I hope is a very simple problem getting started with mySQL. I had the server running earlier this morning and everything seemed fine. But I had to unistall it for some reason (I can't even remember why now!) The problem is, the new installation won't work - the service won't start. It doesnt give any more information than that. I went to the services listing in Windows in order to try and restart the service manually, but as I expected, I got the same problem. Now, I know whats causing the problem - the service installed by the original install is still sitting there. I can tell because if I look at its properties, it still refers to the old installation path. Its as if the uninstaller didn't unistall the service, just everything else. Does anyone know how to fix this and why it happend in the first place. I think I just need to get rid of the service and then everything would be fine. I can't find anything to do with mysql on my computer or in the reg.
View Replies !
MySQL Install On XP Machine
I just installed MySQL on a Windows XP machine, and upon using the SHOW DATABASES command, I was suprised to see that the only table that exists is the 'test' table. Isn't there supposed to be a 'mysql' table there also? Did I miss something?
View Replies !
Migrating My Mysql DB From One Machine To Another
We are moving our mysql db from one machine to another -- both linux. Origin machine is running mysql 3.23, destination machine is running mysql 4.1. Can we simply copy all *.MYD / *.MYI / *.frm files from one machine to the other and have things work? Or do we *NEED* to do a text dump of the tables, and reload each one individually on the new machine?
View Replies !
Anyway To Run 2 Instances Of MySQL On The Same Machine?
I was wondering if there is anyway I can run 2 instances of MySQL Server on the same machine, the reason is I have one machine and I want to be able to simulate my program which really talks between 2 systems accessing their own MySQL server datas but I dont have 2 machines with me all the time to do this, it would be great If I could somehow manage this.
View Replies !
Several Mysql Servers On 1 Machine
Is it possible to setup 2 mysql servers on a Linux platform? For example, both are listening on different sockets. They have different processes, working directory, setup directory. I've seen the my.cnf on my machine but I can't see any socket number.
View Replies !
Connecting To MySql On An XP Machine
I have worked with mySql on my localhost and it does fine. Now I am going to try and login to it from another XP machine. Both machiens are Windows XP Pro SP2. What do I need to type at the command prompt to login to mysql on the other XP machine?
View Replies !
Connect To MySql From Another Machine
I have RHEL 4.0 installed on a x86 box, and am using the standard MySql server that comes with RHEL 4 (MySql version 4.1.12). I tried downloading the Administrator tool, but had problems installing it. (This issue has already been reported at http://forums.mysql.com/read.php?34,65093,65093#msg-65093). I have an Administrator install on a Windows machine, and I want to use it to connect to the MySql server on the RHEL box, but get the error that says: Host '<my_machine>' is not allowed to connect to this MySql Server. Can I use the Windows Administrator tool to connect to a MySql server on Linux? (same network and sub-net) During the RHEL install, the firewall option has been disabled, so that's not an issue. I think I need to add an entrry somewhere in the MySql db that allows other machines to connect, but am unsure of how to add it, and what the syntax looks like.
View Replies !
Access MySQL From Another Machine
how do I make MySQL server accessible from the network to other web servers. Right now I have the MySQL server and the web Server all on the same server. But I want to have a server that is solely responsible for MySQL and 3 others servers that are responsible for web page serving via Apache. The web servers need to be able to access the MySQL database. |-----| |----| |----| |Web | |Web | |Web | |-----| |----| |----| ! ! ! !!!!!!!!!!!!!!!!!!!! | |----| |My- | |SQL | |----|
View Replies !
Mysql Runs On A Machine With Multiple NIC.
When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of user@localhost instead it will be equal to the rights of the user@PrimaryIPAddress. Is this behaviour correct or a bug.
View Replies !
Creating Mysql Database On My Machine
I got complete application files and database files which is in the format of as .sql and i need to recreate this application on my matchine i have already setup application on my iis server but when it comes to setup the mysql database from those .sql files....
View Replies !
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
View Replies !
Connect To Mysql From Fedora To Windows Machine
I installed fedora core 4 which comes with the MySql 4.1.11 version. I have ems mysql manager in another windows machine. I want to be able to connect to the mysql database on the linux box from my windows machine thru mysqlmanager. When I rpovide the host name , user name and password I get an error message not able to connect. Is there anything additional I should do??
View Replies !
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
View Replies !
Connecting To A Remote Mysql Server From A Java Application On Another Machine
i've a java application on a (remote/network) machine and mysql running on my local pc.other users who have access to that remote machine must be able to run that java application which will have to get data/send data to the server(/DB) on my local PC. i was able to run the application when its on my local pC using localhost in the connection string. But, now how do i set the connection string so that the java application accesses the DB (/server) from my local PC?
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
View Replies !
/usr/local/mysql
im getting -can't connect to local mysql server through socket '/var/lib/mysql/mysql.sock' (2) when i try to start.... but for some reason my server crashed last nite... on reboot this folder is no longer there?whats supposed to be there?
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
|
TRACKER
