All Questions
Tagged with sql-server mysql
22
questions
0
votes
2
answers
1k
views
What's the point of having mysql root password for root user?
As a root user on Fedora I have install mysql server with a mysql root password . Then I forgot the password and used sudo mysqld_safe --skip-grant-tables & and bypassed the password , did some ...
0
votes
1
answer
533
views
Problems connecting to database on remotesql.com
I have been using remotemysql.com as a remote database and have had issues attempting to log in since 1.5 days ago.
I'm getting SQL connection error: connect ECONNREFUSED in my app and ...
0
votes
1
answer
857
views
MariaDB: How do I load a copy of a table into RAM for frequent reading?
Colleagues, tell me how to keep a copy of the table in RAM?
I have a database server on MariaDB. One of its databases contains a small table - about five fields and several dozen records. The records ...
-1
votes
1
answer
3k
views
SSIS Error - ODBC Source
I am using ODBC connection to connect to MYSQL in SSIS - the connection is successful, but when the SSIS package is executed, I get the below error.
[ODBC Source [30]] Error: SQLSTATE: 22018, Message: ...
0
votes
1
answer
442
views
Is there a way to run MySQL queries from Windows Powershell or Command Prompt?
I currently use Microsoft SQL Server Management Studio to run queries on my databases, but it's a bit clunky and I prefer to do everything through a CLI if possible. Is there a way to do this on ...
0
votes
1
answer
40
views
What/Where should I look for in trying to rent a server for high-memory computational needs? [closed]
I am in the process of parsing machine-readable data from wiktionary into a SQL database using wikokit, but have since realized that, according to the time estimate provided by wikokit, it will take a ...
0
votes
1
answer
1k
views
Creating MySQL Server on Windows 10 to acces it remotly
I would like to create a MySQL Server on my Windows 10 minicomputer.
I've installed the latest MySQL Server Community, as Server Only.
All works fine, I can access my new database with localhost.
But ...
0
votes
0
answers
112
views
Issue with Microsoft SQL server management studio 2019
When i installed Microsoft SQL server management studio it runs properly with no issue but i have installed XAMPP for mysql on my system but when i run it afterwards SQL server does not working.
does ...
0
votes
2
answers
2k
views
Microsoft SQL Server Management Studio 18 fails to start after installing XAMPP/MAMP on Windows 10
When I try to launch SQL Server Management Studio 18, I get a Windows chime and no other response or error messages. Initially, after installing SSMS 18 and SQL Server 17, both worked fine for a day ...
2
votes
1
answer
2k
views
MySQL Workbench 8.0 Users and Privileges tab is blank
I'm trying to work on an assignment and the professor asked us to create two users to use for the database, however, when I go to the Users and Privileges tab and try to add an account, it is all ...
1
vote
2
answers
4k
views
Can I automatically create a table in mySQL from a csv file with headers as column names?
I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually create a table with a column for each column in the ...
1
vote
0
answers
443
views
Extract data from hundreds of Microsoft Access databases
I have 1,371 Microsoft Access databases (.mdb), each database represents the daily log for a door entry system (so over 4 years worth of daily logs).
Within each mdb file there are only 2 tables: ...
0
votes
1
answer
1k
views
How do I optimize MySQL Server for better performance? [closed]
Recently I had to work with a legacy system. Working with it took a lot of my time because many of the tables were not normalized properly. Due to maintenance issues it is impossible to change. My ...
-2
votes
2
answers
7k
views
How to connect multiple websites to one database in same server
What would you do if you have one server and multiple websites in that server and you want to connect all of the websites to one MySQL database in the server?
I know it decreases the security but I ...
0
votes
1
answer
972
views
MySQL won't start
I recently tried to run a basic MySQL command. Then I got the following response:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I then ...